import - Why am I getting this error with BCP? -


i want import table while keeping identity column.

in cmd, enter:

bcp database.edg.hello in c:\users\tech\downloads\p.csv -c -e -   s349024ijfpok.windows.net\mssqlserver -t 

which returns:

a valid table name required in, out or format options

is issue syntax?

you need brackets database information. use colon " path sure. complete command:

bcp [database].[edg].[hello] in "c:\users\tech\downloads\p.csv" -c -e -s 349024ijfpok.windows.net\mssqlserver -t 

Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

jquery - javascript onscroll fade same class but with different div -