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
 Import/Export (DTS) and Replication (2000)
 importing text file into sql

Author  Topic 

sheebasr
Starting Member

1 Post

Posted - 2008-04-19 : 02:54:14
when i tried this query

BULK
INSERT CSVTest
FROM 'c:\AKSHAYA01-Apr-08.txt'
WITH
(
FIELDTERMINATOR = '~',
ROWTERMINATOR = '\n'
)
GO

i got the error message

Could not bulk insert. File 'c:\AKSHAYA01-Apr-08.txt' does not exist.
how can i rectify this problem
pls help me

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-19 : 09:18:17
As error says check whether file exists in C:.
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2008-04-19 : 10:43:39
The c drive is on the server not your local machine.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-19 : 16:48:04
Ues unc name to reference file if it's not on sql server's local disks, and ensure sql service account has permission to access it.
Go to Top of Page
   

- Advertisement -