运行环境:win7(x64)+SQL 2008+安装了ACCESS DATABASE ENGINEE X64,但是没有安装office.
insert #temp_test SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','\\devw1\temp\TestResult.mdb','select * from tbl_test') AS x
这个语句可以这样写吗?testresult.mdb没有密码,如果用opendatasource如何写?
运行时,出现如下错误:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Procedure mySP_UploadMDB, Line 95
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
求帮助阿。。。。。。谢谢啦