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

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic