各位高手:
服务器配置 Windows Server 2003 R2 32Bit, SQL server2008
安装了AccessDatabaseEngine
Excel2007文件放在服务器上
sp_configure 'show advanced options', 1
reconfigure
go
sp_configure ' Ad Hoc Distributed Queries', 1
reconfigure
go
Select * From
OpRowSet('Microsoft.ACE.OLEDB.12.0', Excel 12.0; Database=d:\tellist.xlsx', 'select * from [sheet1$]');
go
执行后出现如下提示:
Msg 7399, Level 16, State 1, Line 3
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 3
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
请问该如何解决,TKS
------解决方案--------------------
http://blog.csdn.net/Limpire/archive/2008/06/30/2599760.aspx