CODEWITHSUNDEEP
sql-server
user3671271
user3671271

Reputation: 568

Why i can not run the bcp command in command prompt?

I'm beginner in sql server,want to write simple bcp command in command prompt to copy table data into the text file , i write this:

bcp myTABLE out f:\example.txt -S DESKTOP-A5CFJSH\MSSQLSERVER1 -T


but i get this error:
enter image description here


and my table path in sql server is this:
enter image description here
how can i solve that?thanks.

Upvotes: 0

Views: 983

Answers (1)

BNK
BNK

Reputation: 24114

You should use bcp myTestReport.dbo.myTABLE out f:\example.txt -S DESKTOP-A5CFJSH\MSSQLSERVER1 -T instead.

Upvotes: 1

Related Questions