ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to save an excel file to dBase format? (https://www.excelbanter.com/excel-discussion-misc-queries/225822-how-save-excel-file-dbase-format.html)

rdonohue

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

Dave Peterson

How to save an excel file to dBase format?
 
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 wrote:

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


--

Dave Peterson

Bill Sharpe

How to save an excel file to dBase format?
 
rdonohue wrote:
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


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com