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. Check under "Programs and Features" in your Windows control panel to see if Access Database Engine 2007 (32-bit) or 2010 (64-bit) is installed. Uninstall any version you see, then download and reinstall the 2010 64-bit version followed by 2007 32-bit:

Download Microsoft Access Database Engine 2010 64-bit

Download Microsoft Access Database Engine 2007 32-bit

See Also

ModelBuilder error: Microsoft Access Database Engine 2010 64-bit is required to access this data source