使用BCP匯入資料犯的錯

D:>bcp /?
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]

[@more@]

可是我偏偏

D:>bcp run..ofretmsg in -t=, -S 127.0.0.1 -T -i "d:msg.txt" -c
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]無法開啟 BCP 主資料檔案

為啥就不按照語法來呢

D:>bcp dbname..table in "d:msg.txt" -S 127.0.0.1 -T -c -t

開始複製...

已複製 163 行。
網路資料包大小(位元組): 4096
總時鐘時間(毫秒) : 15 平均值: (每秒 10866.67 行。)

使用逗號,做分割符的CVS檔案

D:>bcp dbname..table in "d:/msg.CVS" -S 127.0.0.1 -T -c -t,