i have csv file i'm importing sql table on microsoft sql server. csv file around 1.6 million records long (tab delimited) , contains string each record can (and must retain post-import if in csv file) have apostrophe in it. record similar to:
gb mccombie's court ab10 1aw george st/harbour ward scotland sct aberdeen city
the apostrophes throughout csv file breaking import by, i'm assuming, quoting out half of data until apostrophe found later on, , format destroyed.
is there way can mass escape apostrophes in sql import?
Comments
Post a Comment