Problem using ACE provider to import XLSX using OPENROWSET; JET provider works just fine with XLS


  • Need some help here.

    I have no problem using the JET provider with an openrowset command to extract the contents of an XLS file. However, while using the ACE provider for an XLSX file, I get "OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"."

    I have performed all suggestions as above. ACE is definitely installed as I can see it as a provider in SSMS. I'm confused since JET works fine. Any ideas?

    I am using SQL Server 2005, 32-bit.  

    • Moved by Kalman Toth Saturday, October 12, 2013 7:12 AM Not t-sql
    Friday, October 11, 2013 11:26 PM


All replies