Bulk Insert

[abeckwith]

I am trying to use Bulk Insert to import a text file, but I keep getting an error that the data will be truncated. The file is comma delimited, character data is surrounded by double quotes and numeric data is not. When running the bulk insert, sql server is trying to import the double quotes as well as the data. How do I tell bulk insert that character data has double quotes around it?

Thanks
Angela

 

[CasperTFG]

Are you doing this through DTS, if not you should be. There is a wizard it goes through and one of the options you tell it that test is delimited by : quote, double quote etc. Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!

 

[abeckwith]

I have the import working through DTS. But I wanted to find out if it was possible using Bulk Insert or BCP????