I am trying to add an excel table to my map. I get the message "Failed to connect to database. An underlying database error occurred. Class not registered"
What do I need to do to resolve this error?
Take a look at this article: Error: Failed to connect to database. An underlying database error occurred. Class not registered
Esri Technical Support
Administrative Committee for Pistachios
California Pistachio Research Board
4938 East Yale Avenue, Suite 102
Fresno, California 93727
Office: 559-255-6480, Ext. 101
Fax: 559 255 6485
Please mark this as correct to help other users when they are searching for this same issue! Thanks!
I had the same problem and it worked. Although the driver is supposed to work with 2007 Microsoft Office systems, it solves the problem even if you have Microsoft Office 2016
The page appears to have moved or been dropped for "Error: Failed to connect to database. An underlying database error occurred. Class not registered". Does anybody have the new location?
The previous article does appear to have been removed. If you are receiving this error it may be an indication that the machine being used does not have Microsoft Office installed and will require a driver so that ArcGIS Desktop can view the files.
Please attempt to download the 32-bit Microsoft Access Database Engine 2010 Redistributable Driver
Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center
*The 2007 Office System Driver which was previously the solution has been deprecated by Microsoft and is no longer available for download.
My instance of MS Office was recently upgraded from MS Office 2010 (32-bit) to 2013 (64-bit). I can open .mdb and .xls files in Catalog, but I get the "Failed to connect..." error when I attempt to open. xlsx files.
I'll try the link above and let you know how it goes.
I just tried to install the 32-bit MS Access db engine 2010 driver and I got an error that I already had 64-bit Office installed. I installed the 64-bit driver and still get the original "Failed to connect..." error when trying to open a .xlsx file.
If there are conflicts with the 2010 driver then I would ask that you attempt to install the 32-bit MS Access db engine 2016 found at the following location:
Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center
If problems still persist, I would recommend to reach out to Esri Tech Support to look further into this issue.
I downloaded the 32-bit 2016 MS Access db engine and tried to install it. I got the same error that I did with the 32-bit 2010 Access db engine attempted install (screen capture inserted below).
I'll contact tech support.
As everyone else in this thread has already discovered the Microsoft Access Database Engine 2007 redistributable worked for me, too. It's available from the CNET site at 2007 Office System Driver: Data Connectivity Components - Free download and software reviews - CNET Download.com .
Thanks, Bob!! Just upgraded my computer; neither the 2010 or 2016 redistributable worked for me, and I was having trouble finding the 2007 driver. But, thanks to your link I am now up and running again.
Retrieving data ...