import csv - text data contains valid commas

October 6, 2010 at 14:43:55
Specs: windows server standard
In sql server 2008, trying to use import and export wizard to import a csv file to a table. Set text qualifier as "". Problem is some text fields contain valid commas that are not column separators.

i.e. "BT",12345,"453,606","TEST DATA 2"

The 3rd value should be imported as 453,606 into 1 column. The import is using the comma between 453 and 606 as a column separator even though the value is marked as text with the "". How do I get this value into my table as one value?

See More: import csv - text data contains valid commas

Report •

October 11, 2010 at 10:35:54
I just decided to use pipe delimiters.

Report •
Related Solutions

Ask Question