using bcp

When i was using sql bcp tool to import a file to a table, i got the "unable to open bcp host data-file" error.

 

My command line is simple:

bcp mydb..mytable in "c:/......../file.txt" -T -c

 

It's strange, as i am in the local administrators group, and a sql sysadmin role member. I removed the parameter -T and -c for a try, but failed. They should be important and can't be removed.

 

Then I moved the source file to under c:/ drive, it works. i checked the path again, and found i typed a invalid path for the source file. after modifying that, everything works fine.