Why am I getting the error "A valid table name is required for input, output, or formatting" with BCP?

Question

I want to import a table keeping the identity column.

In cmd, I enter:

bcp database.edg.Hello in C:\Users\Tech\Downloads\p.csv -c -E 
       -S 349024ijfpok.windows.net\MSSQLSERVER -T

Which returns:

The in, out or format parameters require a valid table name

Is this a syntax problem?

+3

user5112255 Jul 14 15 at 15:38

1 answer

Ogglas · Answer 1 · 2016-09-27T09:21:29+0000

You need parentheses for database information. I usually use a colon "

for the path just to be sure. Full command:

bcp [database].[edg].[Hello] in "C:\Users\Tech\Downloads\p.csv" -c -E -S 349024ijfpok.windows.net\MSSQLSERVER -T