How to save an excel file to dBase format?

R

rdonohue

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

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.
 
B

Bill Sharpe

rdonohue said:
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
 
Joined
Jul 1, 2009
Messages
5
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top