SQL Bulk Insert - CSV Problem

I write a comma delimited text file composed from info from another text file. When I try to import this file into SQLEXPRESS/SQL 2005 using 'BULK INSERT' it appears that the first field of the first row is prefixed with 3 characters (ASCII 139,175, 168). This stops the first row from being imported and generates an error message. The extra characters do not show using WordPad, Excel, 'Debug ' or 'Peek'. I actually found them when opening the file with OpenOffice Calc! When I remove the 3 characters in Calc and save, the file will import with BULK INSERT without any problems. How can I get rid of these characters?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories