Applies To
Product(s):	WaterGEMS, WaterCAD, SewerGEMS, SewerCAD, CivilStorm, StormCAD, HAMMER
Version(s):	CONNECT Edition, V8i
Area:	Layout and Data Input
Original Author:	Scott Kampa, Bentley Technical Support Group

 

Problem

When trying to import Excel data into a model using ModelBuilder, the following error message is generate: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

Solution

This issue may be related to the installation of supporting files needed to correctly import the data with Excel. First, try importing the data using the 32-bit version of the program instead of the 64-bit version, as it uses a different version of the Windows component necessary for interacting with Excel files. To do this, browse to C:\Program Files (x86)\Bentley\(program name) and select the application file. For WaterGEMS, this file is called "WaterGEMS.exe", for StormCAD it is "StormCAD.exe", and so on. This is the 32-bit version of the program. Open ModelBuilder and try to import the data.

If this doesn't work, you may need to reinstall the Microsoft Access Database Engine versions in the right order. This is included with the installation as a prerequisite, but if it was uninstalled afterwards, or if there is a problem with the installation order, it could result in this error message. See details here:

ModelBuilder/SCADAConnect error: Microsoft Access Database Engine 2010 64-bit is required to access

Required versions of Microsoft Access Database Engine (ADE)