又换了一种写法,如下:
insert into OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=c:\Info.dbc','tablename.dbf') select * from tablename
OLE DB provider 'MICROSOFT.JET.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: 'c:\Info.dbc'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。]
Info.dbc这个东西我给他换了几个地方都是报上面的错
这样写会产生另外一个错误:
insert into OPENROWSET('MSDASQL','Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=D:\Info.dbc','tablename.dbf') select * from tablename
错误信息:
OLE DB provider 'MSDASQL' reported an error. The provider indicates that the user did not have the permission to perform the operation.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Syntax error or access violation]
insert into OPENROWSET('MSDASQL','Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=D:\Info.dbc','tablename') select * from tablename
这回语法检查通过,可是执行的时候报错:
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Unrecognized command verb.]