title: Importing a CSV file using BULK INSERT command into SQL Server table
body: <p>I have CSV file which have a couple of data columns.</p>
  
  <p>The CSV file looks like</p>
  
  <blockquote>
    <p>field1: Test1<br>
    field2: Test2<br>
    field3: Test3, Test4, Test5</p>
  </blockquote>
  
  <p>In this case which library can I use as field terminator I mean if I use this query to insert CSV file into <code>shopifyitem</code> table as you assume that the data field inserted not correctly   </p>
  
  <pre><code>BULK INSERT shopifyitem
  FROM 'c:\test.csv'
  WITH
  (
     FIELDTERMINATOR = ',',
     ROWTERMINATOR = '\n'
  )
  </code></pre>
  
  <p>So which <em>field terminator</em> can I use?</p>
  
  <p>Thank you so much in advance....</p>