BranchInfo 2010 BranchInfo 2010 BA

Wednesday, August 25, 2010

Saving DBF in Excel 2007 & Later Using ArcCatalog

What a pain in the ass.  Microsoft decides that DBF is a dead format, so you can't output DBF in Excel 2007.  I guess they don't get out much.

When you need to output DBF from Excel 2007, you can use ArcCatalog.  Save the data in a permissible format, say a compatible XLS or a delimited file, and then open it in ArcCatalog and save it as a DBF.



Check back with us at least once a week or so for more fun stuff from Esri-land and beyond.

1 comments:

TheXLWiz said...

You could also try:

SaveDBF that is an Excel 2007 add-in that helps convert and/or save a native DBF file that was edited with Excel 2007.

Two common scenarios are supported:

A) Open a native DBF file in Excel 2007 – Make changes – Save as a native DBF file with the changes.

B) Open/create an Excel file that looks like a database (headers/columns/rows) – Save as a native DBF file.

http://thexlwiz.blogspot.com

Gyula

Post a Comment