Problem: Unable to import Excel files in ArcGIS Pro

Description

Attempts to import Excel files fail and return generic error messages when used in geoprocessing tools in ArcGIS Pro.

Cause

• The Microsoft Access Database Engine driver is not installed.
• The installed Microsoft Access Database Engine driver is not compatible.
• The Excel files are password-protected.
• The Excel files are corrupted.

Solution or Workaround

Depending on the cause, use one of the options below to resolve the issue.

Install the Microsoft Access Database Engine driver

Install the compatible Microsoft Access Database Engine driver on the machine. Refer to ArcGIS Pro: Install the Microsoft Access Database Engine driver for steps and more information.

Use Excel files that are not password-protected

In ArcGIS Pro, unlock the original Excel files if necessary, or use new Excel files that are not password-protected.

Import new Excel files

In ArcGIS Pro, import new Excel files instead of using the corrupted files. Ensure the new Excel files are formatted for use in ArcGIS Pro. Refer to ArcGIS Pro: Format a table in Microsoft Excel for use in ArcGIS Pro for more information.

Related Information

• ArcMap: Understanding how to use Microsoft Excel files in ArcGIS
• ArcGIS Pro: Limitations
• ArcGIS Blog: Guide to connecting to Excel files in ArcGIS Pro

Last Published: 1/13/2022

Article ID: 000027058

Software: ArcGIS Pro 2.9.1, 2.9, 2.8.4, 2.8.3, 2.8.2, 2.8.1, 2.8, 2.7.4, 2.7.3, 2.7.2, 2.7.1, 2.7