.xlsx to .dbf

BRIITO

New Member
Joined
Oct 3, 2008
Messages
19
Hi...I have a report in excel 2007 and I am being asked to present it in .dbf format. It may be simple but I don't know how to change my file from .xlsx to .dbf
Someone suggested to use visual fox pro and I have it iinstalled...but I'm not familiar with it to be honest :(.

Hope someone can give me a hand with this...

thks!
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
SaveDBF is an Excel 2007 add-in that helps users edit and save DBF files and create DBF files from an Excel 2007 spreadsheet.

Highlights:

- Native DBF files retain their original field size after editing.
- However, the add-in is sophisticated enough to identify if a text or integer field needs to increase in size due to the edit.
- The DBF file does not bloat in size.
- Fields that violate dBase standards are highlighted (e.g., field name longer than 10 characters) and also suggestions are added to the cells.
- Large files (over 500,000 records) are supported.
- Now you can add/insert new fields, create calculated fields in addition to adding new records or editing existing records in your native DBF file!
- If you start with an Excel file the software now have enhanced capabilities to determine the field types (better than Microsoft's own in earlier Excel versions).
- Currency fields are now also supported.
- Binary, MEMO, OLE fields are not (yet) supported.
- The original dbf file cannot be overwritten.

More at http://thexlwiz.blogspot.com/
 
Upvote 0
simply install ms office 2003. use ms excel -select file save as dbf. then forget about ms office 2007/2010
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top