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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-14 : 07:27:54
|
| 6.5user writes "Help! I'm stuck in sql 6.5 trying to import data via a csv file into a sql 6.5 db table. BCP returns an error "DB-LIBRARY error:Unexpected EOF encountered in BCP data-file."I took my CSV file don to 1 row, 1 column but still get that error.Is there a way to import multiple rows from a csv file with transact SQL????Thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-14 : 11:30:39
|
| That means you have lines in the file which don't meat the expected format.Do you have the correct line and field terminators and are there any embedded (usually) field terminators in the fields?It is easier to bcp into a single column table then split the data up but in 6.5 you are limitted to 256 chars which may not be enough.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
importing csv to sql 6.5