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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 BULK INSERT

Author  Topic 

thongtran
Starting Member

1 Post

Posted - 2001-06-04 : 04:06:53
Hi All,

I'm using the following piece of code to insert data from text file to sql server:

BULK INSERT NorthWind.dbo.Customers FROM 'c:\Customer.txt'
WITH (DATAFILETYPE = 'char')

and there's error message:

Server: Msg 4860, Level 16, State 1, Line 1
Could not bulk insert. File 'c:\Customer.txt' does not exist.


Please help - Thanks


   

- Advertisement -