|
-
Mar 12th, 2009, 06:21 AM
#1
Thread Starter
Addicted Member
Could not bulk insert
Could not bulk insert because file 'C:\csv\name.txt' could not be opened. Operating system error code 3(The system cannot find the path specified.).
I got the above error.
CREATE TABLE checkcsv
(
col1 varchar(100),
col2 varchar(100)
)
BULK INSERT dbo.checkcsv
FROM '\\IWAPPSVR\IWSQLDB\csv\name.txt'
WITH
(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')
I got the error and i couldnt solve this.solve the query please.
Hope yours reply.
Failing to plan is Planning to fail 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|