English

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

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).

Related Information