ERROR

Jet db Error

Last Published: April 25, 2020

Solution or Workaround

Why do I get "Jet db Error" when I try to open a spreadsheet, such as Lotus, Access, or Excel into Atlas?

This error is generated because Atlas 4.0 does not recognize the Jet libraries of current versions of Microsoft spreadsheets.

When creating a spreadsheet in Lotus, Access or Excel, you should save the file as a dbase IV (.dbf). This can then be opened into Atlas as a .dbf without making Atlas convert the file from another extention such as .xls or .mdb. This is not a problem with older versions of Microsoft spreadsheets written with their extentions, and then brought into Atlas and converted to a .dbf.

If there are further problems try saving the spreadsheet as a text (.txt).

Article ID:000001573

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options