SQL Server Performance

Handling double quotes in a CSV file when using Bulk Insert

Discussion in 'SQL Server 2008 General DBA Questions' started by EMoscosoCam, May 26, 2009.

  1. EMoscosoCam Member

    Hello
    I have a CSV where every single value is surrounded by quotes, even the numbers. I would like to know how to handle this, because the BULK INSERT statement fails when trying to import not only text data, but also numeric data. That is, for example when trying to import the value "1234" into a numeric field then statement fails.
    Thanks a lot.
  2. FrankKalis Moderator

Share This Page