a

• Pradeep-275695

  SSC Enthusiast

  Points: 156

  More actions

  January 25, 2007 at 2:29 am

  #62166

  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.