csv导入sql2000报错
insert into [CHR_CHR_互操作_1x_all_1] select *
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','text','DATABASE=D:\1x.csv')
结果
OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 报错。
[OLE/DB provider returned message: 无效的参数量。]
[解决办法]
SELECT * FROM
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=D:\;Extensions=CSV;',
'SELECT * FROM book1.CSV')
没有啊
