''Microsoft.ACE.OLEDB.12.0'' reported an error. Access denied.

• Pradeep-275695

  SSC Enthusiast

  Points: 156

  More actions

  January 25, 2007 at 2:33 am

  #103305

  I’m trying to run a SQL script accessing 2007 Excel file (*.xlsx) 

  However, it give me an error below:

  Server: Msg 7403, Level 16, State 1, Line 40

  Could not locate registry entry for OLE DB provider 'Microsoft.ACE.OLEDB.12.0'. OLE DB error trace [Non-interface error:  Provider not registered.].

   I installed Office 2007 but it is now giving following error.

  Server: Msg 7399, Level 16, State 1, Line 40

  OLE DB provider 'Microsoft.ACE.OLEDB.12.0' reported an error. Access denied.OLE DB error trace [OLE/DB Provider 'Microsoft.ACE.OLEDB.12.0' IUnknown::QueryInterface returned 0x80070005:  Access denied.].

  I am not sure what does this error represent.

• January 29, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Joy Garon

  Right there with Babe

  Points: 733

  More actions

  February 23, 2007 at 8:47 am

  #691429

  Assuming you are using SQL Server 2005 - did you download SP2? It's my understanding that SP2 is required...