SQL Server 2008 64bit Standard Edition on Windows 2008 R2 Standard
I have already installed AccessDatabaseEngine_x64 and I see Microsoft.ACE.OLEDB.12.0 in the list of providers under linked server.
I have enabled Ad Hoc Distributed Queries
sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO
The SQL Server service is running under an account that has full access to the directory and file.
But when I run the my OPENROWSET command :
SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\SQLFTP\somespreadsheet.xls;HDR=YES', 'select * from [List1$]');
I see the following error :
Msg 7399, Level 16, State 1, Line 2 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 2 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
Is restarting Windows required after installing AccessDatabaseEngine_x64? Or is there something else wrong?
Thank you in advance.