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"
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 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
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:
