在SQLSERVER2008中导入EXCEL2007文件的问题
各位高手:
    服务器配置 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