多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成!
用外部dbf文件导入SQl时
insert into [xszdzj]([XH],[XM],[BJM]) select [学号],[姓名],[班级] from OPENROWSET
('Microsoft.JET.OLEDB.4.0','Dbase IV;HDR=YES;IMEX=2;DATABASE=D:\Documents and Settings\Jackey1.JACKEY\桌面\','select * from [Xszd]')
执行时报错
One or more properties could not be set on the query for OLE DB provider 'Microsoft.JET.OLEDB.4.0'. The provider could not support a required property.
[OLE/DB provider returned message: 多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。]
大家看看是什么原因啊???