Y W,

   bcp database..table in c:\test\test.txt /c

You might check for the other "flags" that may be used in "Books Online" or
other help on BCP.

I am trying to import a text file by using the following command :-

bcp employee in c:\test\test.txt /c

However it reports :-

Msg 156, Level 15, State 1
Incorrect syntax near the Keyword 'in'.

What is the correct syntax ?

Y W Wong

Y W Wong,

I can not replicat your problem here.  I presume you have typed in an
example of the command you used rather than the actual command as the first
message you would have received would have been the prompt for a password.

Please can you post up the exact example, the table structure and some
sample data and I will have another go

Steve Robinson

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Now it reply :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any more idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Hi

Check out the BCP help by typing "BCP /?" at the command prompt.

The dbtable is database.owner.table.  Also check out the /S switch
(server) if you are executing this command from a machine other than
the SQL Server host.

ie::

bcp MyDatabase.dbo.Postal_Codes in e:\datafile\dlpost /c /t ~ /m 500
/U xx /P ***** /S Server

Al
-------------------------------------------

You are trying to run bcp from a SQL Query window. BCP is not a SQL
Command, it must be run from an operating system (DOS) command prompt.
--
Kalen Delaney
MCSE, SQL Server MCT, MVP

You are trying to run bcp from a SQL Query window. BCP is not a SQL
Command, it must be run from an operating system (DOS) command prompt.
--
Kalen Delaney
MCSE, SQL Server MCT, MVP