How do I create a DBF file in Microsoft Excel 2007?
In Microsoft Excel 2007, there is no option to save the table in .dbf (dBASE) format as in previous versions. This is by design with Microsoft Office 2007. Export an Excel table to .dbf format in ArcGIS: • In Excel 2007, save the table as, ‘Excel 97-2003 Workbook’ (.xls format). • Navigate to the .xls table location through ArcCatalog, and expand the file to view the worksheets. • Right-click on the worksheet representing the table. Select Export > To dBase (single).