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.
   

   EMoscosoCam, May 26, 2009

   #2
2. FrankKalis Moderator

   I'm guessing that the values are separated by a comma. So what happens when you specify WITH (FIELDTERMINATOR = '","') in the BULK INSERT command?
   For more info, see if this helps: http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
   

   FrankKalis, May 27, 2009

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in