ERROR

Failed to connect to database. An underlying database error occurred. Class not registered

Last Published: May 10, 2024

Error Message

Note:
ArcMap is in Mature support and will be retired March 1, 2026. There are no plans for future releases of ArcMap, and it is recommended that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro for more information.

In some instances, when adding a Microsoft Excel table to ArcMap, or trying to expand an Excel spreadsheet in ArcCatalog, the following error message is returned:

Error:   
Failed to connect to database. An underlying database error occurred. Class not registered
Failed to connect to database. An underlying database error occurred. Class not registered

Cause

The error occurs because Microsoft Office System Driver is not installed on the machine. This prevents ArcMap from reading .xls and .xlsx file formats. Refer to ArcMap: Understanding how to use Microsoft Excel files in ArcGIS for more information.

Solution or Workaround

To resolve this issue, use one of the following options:

Install Microsoft Access Database Engine (32-bit)
Microsoft Access Database Engine installs a set of components that can be used to facilitate the transfer of data between 20xx Microsoft Office System files and non-Microsoft Office applications such as ArcMap. Since ArcMap runs on a 32-bit application, install the 32-bit Microsoft Access Database Engine 2016 from the Microsoft Download Center.

Note:
Refer to Microsoft Access Database Engine 2016 Redistributable for more information on the latest Microsoft Access Database Engine.

Save the Excel file in a .csv file format

  1. Open the tabular data or Excel file in Microsoft Excel.
  2. Click File and select Save As.
  3. Under the Save as type drop-down list, select CSV (Comma delimited), and click Save to save the file in a .csv format.
Save Excel sheet as .csv

Use the Excel To Table tool

The Excel To Table tool converts Microsoft Excel files into a table.

  1. In ArcMap, navigate to Toolboxes > System Toolboxes > Conversion Tools > Excel > Excel To Table.
  2. In Input Excel File, browse the Excel file.
  3. Set a name and location for Output Table.
  4. Click OK to execute the tool.
The Excel To Table tool
Note:
In some cases, saving .xlsx files to the older version .xls file may circumvent the error.

Article ID:000013670

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options