PROBLEM

Microsoft Office 2007 Excel does not allow tables to be saved as .dbf format

Last Published: April 25, 2020

Description

When working with a table in Microsoft Excel 2007, there is no option to save the table in .dbf (dBASE) format as in previous versions.

Cause

This is by design with Microsoft Office 2007.

Solution or Workaround

Export an Excel table to .dbf format in ArcGIS.

  1. In Excel 2007, save the table as, 'Excel 97-2003 Workbook' (.xls format).
  2. Navigate to the .xls table location through ArcCatalog, and expand the file to view the worksheets.
  3. Right-click on the worksheet representing the table. Select Export > To dBase (single).

Article ID:000009760

Software:
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic