How to reconvert a .xls file to a .dbf file?

Question

I had opened a .dbf (Dbase format )file with MS-Excel,where it opened just fine.But now I can't open the same file with DBase.
Can Anyone Please help me out on this,with the easiest possible solution?

I had opened a .dbf (Dbase format )file with MS-Excel,where it opened just fine.But now I can't open the same file with DBase.
Can Anyone Please help me out on this,with the easiest possible solution.Kindly elaborate Stepwise.How do I make it compatible with Dbase?

Answer 1

You will have to convert XLS to a DBF compatible file.
Excel in Office 2003 allows you to save the File as a Dbase 2,3 or 4 format. However, this is no Guarantee, you may have to have a conversion option in the Dbase Program, OR Take it to a file format that Dbase will accept... I have seen some Programmers use an intermediate XML for use in other Programmes that use an XML format, but there are a lot of factors I don't know about your situation, so the above is just a few thoughts
Some info:
http://www.whitetown.com/dbf2xls/

Answer 2

After you have the file opened in Excel and finish working with it, go to File -> Save As.

There, in File type choose ".dbf", and save. I think this is probably the easiest way

Answer 3

Open the Excel file
click File, Save AS
filetype: CSV (comma delimited)

A file in this format can be imported into almost any other datafile you can name.

You had better decide which program you want to stay with or you will be converting constantly.

Answer 4

you may convert your excel record to dbf format utilising some changing techniques application. you will locate loose or license application on the cyber web. one in all that application is dbfview. you should use that application to transform your xls or xlsx data to dbf format. thank you