|
|
Posted by Mike on 10/13/05 20:48
I am trying to use the 'Bulk Insert' command to load a data file into a
MS-SQL db. The line I am using is:
Bulk Insert SVC_Details From "C:\XFILE.TXT" With (FieldTerminator = ',')
I have tried the file name with " around it and with ' around it and both
the " and ', but every time the Query Analyzer comes back with the following
error:
---Begin Error Msg---
Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file ''C:\XFILE.TXT'' could not be opened.
Operating system error code 123(The filename, directory name, or volume
label syntax is incorrect.).
---End Msg---
I am not sure what is wrong with this line. Can any one tell me what is
wrong?
Mike
m charney at dunlap hospital dot org
Navigation:
[Reply to this message]
|