Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimjamjo
Starting Member
10 Posts |
 Posted - 2005-07-13 : 15:44:46
|
| HiI'm trying to BULK IMPORT A txt file but am unsure of the row terminator as I don't know how the file was created. It looks like a simple vbcrlf. I've tried:\nresult:Column is too long in the data file for row 1, column 26. Make sure the field terminator and row terminator are specified correctly\r\nresult: As Above\oaresult:Bulk insert data conversion error (truncation) for row 1, column 26 (VAT).Bulk insert data conversion error (truncation) for row 2, column 26 (VAT).Bulk insert data conversion error (truncation) for row 4, column 26 (VAT).Bulk insert data conversion error (truncation) for row 5, column 26 (VAT).Bulk insert data conversion error (truncation) for row 7, column 26 (VAT).Bulk insert data conversion error (truncation) for row 8, column 26 (VAT).Bulk insert data conversion error (truncation) for row 10, column 26 (VAT).Bulk insert data conversion error (truncation) for row 12, column 26 (VAT).Bulk insert data conversion error (truncation) for row 14, column 26 (VAT).\lfresult: Bulk insert data conversion error (truncation) for row 1, column 26 (VAT).Bulk insert data conversion error (truncation) for row 2, column 26 (VAT).Bulk Insert fails. Column is too long in the data file for row 3, column 26. Make sure the field terminator and row terminator are specified correctly.any ideas please? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-13 : 15:52:36
|
| How about \r? There's really no way for us to know what format the file is in without using a hex editor to see what's in there. Can't you contact the owner of the file?Tara |
 |
|
|
jimjamjo
Starting Member
10 Posts |
Posted - 2005-07-14 : 14:45:31
|
| Hi - thanks for the hex editor info - I downloaded xv132 and I'm sure it'll come in useful. It showed up 0D 0A as the last characters. I just replaced them with :| and used that instead as my fingers are going numb! |
|
|
|
|
|
|
|
|
ROWTERMINATOR = *****