SELECT *
INTO JZPT_736
FROM OPENROWSET('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=F:\TABLES',
'select * from jzpt736.DBF')提示:
OLE DB 提供程序 'MSDASQL' 报错。
[OLE/DB provider returned message: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能]
OLE DB 错误跟踪[OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]。也试过这个:
SELECT * INTO JZPT_736
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=F:\TABLES\',
'select * from jzpt736.DBF')
提示:
未能处理对象 'select * from jzpt736.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 jzpt736.DBF']。 在网上查过很多资料,好像没有一个办法可以的。之前的运行第一条sql语句是没有问题的,后来重装系统后就不行了。请各位高手帮帮忙,谢谢!
INTO JZPT_736
FROM OPENROWSET('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=F:\TABLES',
'select * from jzpt736.DBF')提示:
OLE DB 提供程序 'MSDASQL' 报错。
[OLE/DB provider returned message: [Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能]
OLE DB 错误跟踪[OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]。也试过这个:
SELECT * INTO JZPT_736
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=F:\TABLES\',
'select * from jzpt736.DBF')
提示:
未能处理对象 'select * from jzpt736.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 jzpt736.DBF']。 在网上查过很多资料,好像没有一个办法可以的。之前的运行第一条sql语句是没有问题的,后来重装系统后就不行了。请各位高手帮帮忙,谢谢!
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=F:\TABLES\jzpt736.DBF',
'select * from tableName')
select * from jzpt736.DBF'
这条语句好象有误吧
这里比较全
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'dBase IV;HDR=NO;IMEX=2;DATABASE=C:\','select * from [客户资料4.dbf]')
--*/
(2)--/* dBase III文件
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'dBase III;HDR=NO;IMEX=2;DATABASE=C:\','select * from [客户资料3.dbf]')
--*/
(3)--/* FoxPro 数据库
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
--*/