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
 General SQL Server Forums
 New to SQL Server Programming
 error message while loading

Author  Topic 

yrkrish
Starting Member

6 Posts

Posted - 2007-11-09 : 15:07:28
Hi,


while doin bulk insert i am gettin the following error


BULK INSERT [dbo].[module]
FROM 'c:\data\MIL.csv'
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)

Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "c:\data\MIL.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.).

Can any one suggest a solution ?

Thanks,
Yrkrish.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-09 : 15:09:45
cross post found here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92401



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -