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:
InformationAttempted 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) ...
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.
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"
Keywords: OLEDB, TFS 78121