Greetings. I am using BULK INSERT to import data to a table from a text file. One table column is varchar(max) and I wish to import text that has carriage returns and preserve the carriage returns in the database. Basically, I am importing
newspaper articles stripped of all special characters except quotes, double quotes, and CR's. The Bulk Insert works just fine, except it strips out the carriage returns.
I am using an XML Format File and the field terminators are tabs.
Any help on this would be greatly appreciatede. Thanks.
View Complete Post