SELECT * FROM OPENROWSET('sqloledb.1','mrp-server';'sa';'123',DBdata.dbo.tbG_gzzxzl)
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'd:/aaa.xls';'admin';'', data)
AS a
以下语句能成功,上一天语句却不行:OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 报错。
[OLE/DB provider returned message: 不可识别的数据库格式 'd:/aaa.xls'。]
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:/aaa.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...data$
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...abc$
insert into OPENDATASOURCE('sqloledb','Data Source=mrp-server;User ID=sa;Password=12345').voutmmstdata.dbo.zcctest (cust_no,cust_name)
SELECT cust_no,cust_name
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="c:/111.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...getbom1$
select * from OPENDATASOURCE('SQLOLEDB', 'Data Source=mrp-server;User ID=sa;Password=12345').voutmmstdata.dbo.zcctest
delete from opendatasource('sqloledb','Data Source=mrp-server;User ID=sa;Password=12345').voutmmstdata.dbo.zcctest
这条语句在ACCESS数据库不带密码的时候也能成功运行,加上寄密码之后按照以下写法却不行:其中abc密码.
SELECT a.*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'd:/demo.dat';'admin';'abc', temp)
AS a
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)