I have a vendor-supplied CSV file in the format:
As you can see, the fields are enclosed in double quotes and separated by commas.
Some fields have commas within the data, for example, the value for Field2 could be "A,B,C"
I tried to import data using BULK INSERT. When I specify the FIELDTERMINATOR as ',', bad things happen, the value in Field2 is broken on each comma, the enclosing double quotes are inserted as part of the value. When I specify the FIELDTERMINATOR as '","' , everything looks Ok, but the first field has a leading and the last field has a trailing double quote.
Is there a way I could make BULK INSERT import the data from my CSV file properly?