请教大侠！对BCP命令熟悉的请进
我有一个文件： d:\temp.txt
文件内容为：
"f ", "a ", "s ", "## ", "q ", "w ", "e ", "## ", "d ", "j ", "k ", "## ",……, "f ", "h ", "k ", "## "
----------------
我现在用 BULK INSERT 句子：
BULK INSERT tmpbill FROM 'd:\temp.txt '
WITH (
DATAFILETYPE = 'char ' ,
FIELDTERMINATOR = ', ' ,
ROWTERMINATOR = ' "## " ',
)
----------------
在导数据的时候报错：错误是在数据文件中遇到意外的文件结尾（Eof）；然后我把最后的 "## "去掉就没有问题了；
----------------
在这里我想请问如何让它不去掉最后的 "## "也不报错，也就是加一个终止符（\ln），那个参数是什么？
----------------
先谢谢！！！
[解决办法]
select * into tmp_Table from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=D:\; ', 'select * from tmp.txt ')
[解决办法]
导文本:
select * into tmp_Table from OpenRowset( 'MSDASQL ', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=D:\; ', 'select * from tmp.txt ')
-------------------------------------
导Execl:
SELECT * into tmp_Table FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0 ', 'Data Source=
D:\ttt.xls;
Extended Properties= "Excel 5.0;HDR=Yes; ";Persist Security Info=False ')...页1$
