You are currently reviewing an older revision of this page.
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."
This issue may be related to the installation of supporting files needed to correctly import the data with Excel. The first thing to try is to import the model using the 32-bit version of the program instead. 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, the correct installation of the Access Database Engine may not be installed on your computer. This is included with the WaterCAD installation as a prerequisite, but if it was uninstalled afterwards, it could result in this error message. Check under "Programs and Features" to see if Access Database Engine 2007 (32-bit) or 2010 (64-bit) is installed. If not, try reinstalling WaterCAD.
ModelBuilder error: Microsoft Access Database Engine 2010 64-bit is required to access this data source