How to save an excel file to dBase format?

[rdonohue]

Using Excel 2007, how do I save a file to dBase format? Is there an add-in or
utility for this?

 

[Dave Peterson]

Did you get Access 2007, too?

If yes, maybe you can copy|paste the data there. From what I've read, it still
supports .dbf files.

 

[Bill Sharpe]

Using Excel 2007, how do I save a file to dBase format? Is there an add-in or
utility for this?

If you can save the Excel workbook with an xls extension, i.e.
compatible with earlier versions of Excel, you can then open it in
OpenOffice.org's Calc program. From there you can save it as a dbf file.

OpenOffice.org is free, but it's a huge download.

As Dave suggested, Access 2007 also supports saving a table as a DBF.

Bill

 

[gygulyas]

Save DBF in Excel 2007

XLSX2DBF 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