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
Thanks
Angela