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 - 2002-07-08 : 08:48:36
|
| Padmini writes "I tried the code below:BULK INSERT tblTest FROM 'TxtFile2.txt' WITH (FIELDTERMINATOR = ',')However i keep on getting the following error in the SQL Query AnalyserError:Server: Msg 4860, Level 16, State 1, Line 1Could not bulk insert. File 'TxtFile2.txt' does not exist.The file is there in the C:\ drive and the table (tblTest) is also in the database. Why then am I getting this error?" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-07-08 : 08:48:36
|
How about
BULK INSERT tblTest FROM 'c:\TxtFile2.txt' WITH (FIELDTERMINATOR = ',') |
 |
|
|
|
|
|
Bulk insert