topic Re: Editing a DBF file in excel 2010? in Data Management Questions

Editing a DBF file in excel 2010?

SergeBisson — Thu, 02 Feb 2012 21:16:57 GMT

In older versions of excel you could open a DBF file, edit the data like you would in excel and save the file as the DBF file. In Arc you could then open the shape file with the new editied DBF file. In excel 2010 you can open the file but you can't save it. Does anyone have a way around this. Is there a free add on that we can edit DBF files with. I guess the alternative is to run a version of excel 2003 but I view this as a last resort.

Thanks
Serge

Re: Editing a DBF file in excel 2010?

MelitaKennedy — Thu, 02 Feb 2012 21:46:17 GMT

Hi Serge,

You may be able to save as dbf using Access rather than Excel.

Melita

Re: Editing a DBF file in excel 2010?

DanPatterson_Retired — Thu, 02 Feb 2012 23:51:05 GMT

or Open Office which is free

Re: Editing a DBF file in excel 2010?

GYULAGULYAS — Sun, 12 Feb 2012 23:03:42 GMT

You could also try the SaveDBF Excel 2010 32-bit add-in. The demo can be downloaded at thexlwiz.blogspot.com

Re: Editing a DBF file in excel 2010?

LesPowrie — Fri, 04 Oct 2013 14:51:55 GMT

How do I change a field property from double to integer? I could do this in Excel, but it does not seem to work in LibreOffice, and Excel 2007+ does not allow saving a DBF.

Re: Editing a DBF file in excel 2010?

RionaAskara — Tue, 24 Feb 2015 14:21:14 GMT

It's irritatingly roundabout but you can save to Excel, run the Excel to Table script and replace your old dbf by deleting and renaming in Windows explorer. It'd be nice if we could skip that last step by being permitted to overwrite an existing table in Excel to Table, but if wishes were horses, etc.