Address Coder may fail when the input file is Excel, with the error message: Unexpected error from external database driver (1)

Last Published: April 25, 2020

Error Message

When using an Excel file as the input for Address Coder, the following error may be returned:

Unexpected error from external database driver (1)


The October 14th, 2017 Microsoft update has been determined to be the cause of this issue. 

Solution or Workaround

This issue can be addressed by installing the Microsoft patch appropriate for your Operating System, available from the following link:

 Once the appropriate patch is installed the issue will be eliminated and Address Coder will work as expected with Excel and all other supported inputs.

The patch is not specific to any version of Address Coder and addresses the problem across all releases.

Article ID:000017634

  • Other

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic