|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?