title: Bulk insert with text qualifier in SQL Server
body: <p>I am trying to <code>bulk insert</code> few records in a table test from a CSV file , </p>
  
  <pre><code> CREATE TABLE Level2_import 
   (wkt varchar(max),
   area VARCHAR(40),
   ) 
  
  
  BULK
   INSERT level2_import 
   FROM 'D:\test.csv'
   WITH
   (
   FIRSTROW = 2,
   FIELDTERMINATOR = ',',
   ROWTERMINATOR = '\n'
   )
  </code></pre>
  
  <p>The bulk insert code should rid of the first row and insert the data into the table  . it gets rid of first row alright but gets confused in the delimiter section . The first column is wkt and the column value is double quoted and has comma within the value . </p>
  
  <p>So I guess I question is if there is a way to tell the <code>BULK INSERT</code> that the double quoted part is one column regardless of the comma within it ?</p>
  
  <p>the CSV file looks like this , </p>
  
  <pre><code> "MULTIPOLYGON (((60851.286135090661 510590.66974495345,60696.086128673756 510580.56976811233,60614.7860844061 510579.36978015327,60551.486015895614)))", 123123.22
  </code></pre>