title: How to Bulk Insert csv with double quotes around all values?
body: <p>I am trying to insert a .csv file into SQL Server 2008 R2.</p>
  
  <p>The .csv is 300+MB from <a href="http://ipinfodb.com/ip_database.php" rel="nofollow noreferrer">http://ipinfodb.com/ip_database.php</a> Complete
  (City), 4.0M records.</p>
  
  <p>Here're the top 5 lines, with 1st line = column headers:</p>
  
  <pre><code>"ip_start";"country_code";"country_name";"region_code";"region_name";"city";"zipcode";"latitude";"longitude";"metrocode"
  "0";"RD";"Reserved";;;;;"0";"0";
  "16777216";"AU";"Australia";;;;;"-27";"133";
  "17367040";"MY";"Malaysia";;;;;"2.5";"112.5";
  "17435136";"AU";"Australia";;;;;"-27";"133";
  </code></pre>
  
  <p>I tried Import and Export Data, and BULK INSERT, but haven't been able to import them correctly yet.</p>
  
  <p>Shall I resort to use bcp? can it handle stripping the <code>""</code>? how?</p>
  
  <p>Thank you very much.</p>