Hi all, I'm using VB6.0 and SQL Server 7.0 to do my thing. When I use the Bulk Insert in VB to import data from a flat file into SQL I get the following error message:
Bulk Insert Data Conversion Error (truncation) for row 1, column 2.
I agree that this error is very descriptive and points you straight to the problem, but, in the import file, this field is only 1 char while in the database, column 2 is 2 chars long. I don't see where the truncation comes in during the import. If anyone knows how to fix this or point me in the right direction, it will be appreciated. Any comments are welcome. Have a good day/night, wherever you are.
Bulk Insert Data Conversion Error (truncation) for row 1, column 2.
I agree that this error is very descriptive and points you straight to the problem, but, in the import file, this field is only 1 char while in the database, column 2 is 2 chars long. I don't see where the truncation comes in during the import. If anyone knows how to fix this or point me in the right direction, it will be appreciated. Any comments are welcome. Have a good day/night, wherever you are.
