Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
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?