Frank you didn't mention that you'd enclosed the table specification in .
Try [rms-prc]..audit_actions if that is your database name.
> and the terminating ')' was missing from the WITH clause. Also the data
> file needs to be on the actual server machine, even though I'm running
> Analyzer on my local workstation.
> > I'm trying to bulk copy data from a text file into Sql2000. When I
> > the following into Sql2000 Query Analyzer:
> > bulk insert rms-prc..audit_actions
> > from d:\sqlserver\rms\import\EXP_AUDIT_ACTIONS.TXT
> > with (DATAFILETYPE = 'char',
> > FIELDTERMINATOR = '_',
> > ROWTERMINATOR = '\n'
> > I get the following error:
> > Server: Msg 170, Level 15, State 1, Line 1
> > Line 1: Incorrect syntax near '-'.
> > This is very confusing since there is no '-' character anywhere in my
> > statement. What's the problem here? Using bcp utility from commandline
> > gives the same error.
> > -Frank Brown
> > Seattle Fire Dept
> > http://www.inwa.net/~frog/