Product(s):	Promis.e, Bentley Substation
	Version(s):	08.11.13.57 - 08.11.13.140
	Environment:	N\A
	Area:	Automation Features
	Subarea:	Project API Builder

Error or Warning Message

After specifying a .XLSX file on the [[Project API Builder]] dialog or in [[Project Manager]] > BOM Explorer > Import Spreadsheet Into BOM, an error message appears that includes the following text.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

In one case the error message was:

Information
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
   at System.Data.Common.UnsafeNativeMethods.lDBlnitializelnitialize.lnvoke(lntPtr pThis)
   at System. Data.OleDb.DataSourceWrapper.lnitializeAndCreateSession(OleDbConnectionString constr. SessionWrapper sessionWrapper)
   at System. Data.OleDb.OleDbConnectionlnternal..ctor(OleDbConnectionString constr. OleDbConnection connection) ...

How to Avoid

In the case of a Windows 8.1 64-bit operating system with 64-bit Microsoft Office 365/2016 installed, the error message was resolved by installing the 2007 accessdatabaseengine.exe available here.

External Links

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

Original Author:

Matt_P

Keywords: OLEDB, TFS 78121