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 - 2001-12-04 : 09:15:49
|
| Halmet writes "i'm trying to transfer data from a text file to table using BULK INSERT.this is the error message i get in Query Analyer-------------Server: Msg 4832, Level 16, State 1, Line 1Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.The statement has been terminated.your help is appreciated!halmet" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2001-12-04 : 10:36:24
|
| If there is a newline as the last character, remove the newline and readd it yourself and save the file and try it again.*************************Just trying to get things done |
 |
|
|
|
|
|
copy text file to table