我有一个文件: 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),那个参数是什么?
----------------
先谢谢!!!
文件内容为:
"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),那个参数是什么?
----------------
先谢谢!!!
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$