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.



Wednesday, August 25, 2010
Subscribe to:
Post Comments (Atom)
1 comments:
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