SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0', 'dBase 5.0;DATABASE=F:\', 'select * from [DEVELOPT.DBF]')--DEVELOPT.DBF文件位于F:\,并且里面是有列并且有数据的-----------------------------------------------------------------
服务器: 消息 7357,级别 16,状态 2,行 1
未能处理对象 'select * from [DEVELOPT.DBF]'。OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 指出该对象中没有任何列。
OLE DB 错误跟踪[Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='MICROSOFT.JET.OLEDB.4.0', Query=select * from [DEVELOPT.DBF]']。
服务器: 消息 7357,级别 16,状态 2,行 1
未能处理对象 'select * from [DEVELOPT.DBF]'。OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 指出该对象中没有任何列。
OLE DB 错误跟踪[Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='MICROSOFT.JET.OLEDB.4.0', Query=select * from [DEVELOPT.DBF]']。
---------------------------------------------------
SELECT
*
INTO NewTableName
FROM
OPENROWSET(
'MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=D:\','SELECT * FROM [Po2.DBF]
')
----------------------------------------------------------------------
SELECT
*
INTO NewTableName
FROM
OPENROWSET(
'MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=F:\','select * from [DEVELOPT.DBF]
')
---------------------------------------------------------------------
服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB 提供程序 'MSDASQL' 报错。
[OLE/DB provider returned message: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能]
OLE DB 错误跟踪[OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]。