import - Importing DBF files to MS Excel 2007

Question

I am trying to import DBF file to Excel. But after I am importing it, it doesnt show data in proper format. I guess there is some problem with encoding. I tried using different encodings in "File Origin" option. Could anybody guide me in this matter.?

Thanks

Answer 1

It is an encoding issue indeed. Windows "translates" your DBF characters to the default system code page when opening the file. There are ways around if you know your original code page but it is not for the faint hearted.