title: Bulk Import CSV file into SQL Server - remove double quotes
body: <p>I am running SQL 2008, bulk insert command, while inserting the data, I am trying to remove (") double quotes from the CSV file, which works partially, but doesnt work for all the records, please check my code and the screenshot of the result.</p>
  
  <pre><code>Bulk Insert tblUsersXTemp 
   from 'C:\FR0250Members161212_030818.csv'
   WITH (FIELDTERMINATOR = '","', 
   ROWTERMINATOR = '"\n"',
   --FormatFile =''
   ERRORFILE = 'C:\bulk_insert_BadData.txt')
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/MHenV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MHenV.png" alt="enter image description here"></a></p>