none
How resolve error OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error"

    Question

  • Error:

    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 am using the following query 

    select * from openrowset('Microsoft.ACE.OLEDB.12.0'
    ,'Excel 12.0;Database=\\abc\k\excel.xlsx',[sheet1$])

    driver Microsoft.ACE.OLEDB.12.0 installed and configure properly.

    Any help ?

    Thursday, April 9, 2015 12:18 PM

Answers

All replies