excel 2007 to dbf


Is there a was to save excel 2007 to a dbf file?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
You can open a blank access and IMPORT everything from Excel..it should do the trick.
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.