We help IT Professionals succeed at work.

excel 2007 to dbf

Hi

Is there a was to save excel 2007 to a dbf file?
Comment
Watch Question

No such way exist. You have to save it in different format and convert such format into DBF. Or you may save it as Excel 2003 workbook and import this XLS file into DBF in some RDBMS, like Visual FoxPro, dBase, etc.

Also XML format is readable in many RDBMS but nothing works on one click...

Commented:
You can open a blank access and IMPORT everything from Excel..it should do the trick.
Commented:
and you can either link your sheets (as tables) in access or just import them...works like a charm
You can open a .xlsx (Excel 2007 format) spreadsheet in a prior version of Excel (2003, XP, or 2000), using the compatibility pack found at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466. The prior versions of Excel can create DBF output directly.
You can import your excel 2007 sheet in Access2007 and then can export from Access2007 to Dbase iii/IV type dbf.

Excel don't but Access Do support dbase format

Bm Keshav