How to save an excel file to dBase format?

  • Thread starter Thread starter rdonohue
  • Start date Start date
R

rdonohue

Using Excel 2007, how do I save a file to dBase format? Is there an add-in or
utility for this?
 
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.
 
rdonohue said:
Using Excel 2007, how do I save a file to dBase format? Is there an add-in or
utility for this?
Click to expand...

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

Similar Threads

why excel 2007 does not support dbase file type? 2
save excel 2007 file as database III 2
Problem with dBase 3
2007 Excel to Dbase 1
How can I save excel files to a DBASE format in excel 2007? 4
Slow sumproduct Dbase 2
When will save as "DBF" be a reality from Excel 2007 ? 1
Saving Excel file in DBase IV format 9

Back
Top