运行
select * into tempTable from
openrowset
('MICROSOFT.JET.OLEDB.4.0','dBase 5.0; DATABASE=\\192.168.1.8\data\','select * from data.dbf')
后
OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 报错。
[OLE/DB provider returned message: Microsoft Jet 数据库引擎找不到对象'Sjshq.dbf'。请确定对象是否存在,并正确地写出它的名称和路径。]
OLE DB 错误跟踪[OLE/DB Provider 'MICROSOFT.JET.OLEDB.4.0' IColumnsInfo::GetColumnsInfo returned 0x80004005: ]。但是把dbf下载到本机上改成
select * into tempTable from
openrowset
('MICROSOFT.JET.OLEDB.4.0','dBase 5.0; DATABASE=c:\','select * from data.dbf')
却成完成运行,请问这中间是哪儿有问题呢?
select * into tempTable from
openrowset
('MICROSOFT.JET.OLEDB.4.0','dBase 5.0; DATABASE=\\192.168.1.8\data\','select * from data.dbf')
后
OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 报错。
[OLE/DB provider returned message: Microsoft Jet 数据库引擎找不到对象'Sjshq.dbf'。请确定对象是否存在,并正确地写出它的名称和路径。]
OLE DB 错误跟踪[OLE/DB Provider 'MICROSOFT.JET.OLEDB.4.0' IColumnsInfo::GetColumnsInfo returned 0x80004005: ]。但是把dbf下载到本机上改成
select * into tempTable from
openrowset
('MICROSOFT.JET.OLEDB.4.0','dBase 5.0; DATABASE=c:\','select * from data.dbf')
却成完成运行,请问这中间是哪儿有问题呢?
openrowset
('MICROSOFT.JET.OLEDB.4.0','dBase 5.0; DATABASE=\\192.168.1.8\data\','sj';'sj','select * from data.dbf')