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
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.
Try Excel DbfMate Add-In. It allows importing data from DBF files directly to worksheet, and exporting data from worksheets to DBF files using either GUI or VBA. Handles character encoding. Supported Excel versions: 2007 to 2013. Supported DBF formats: dBase III, VFP, dBase IV (import only). A demo is also available on Softpedia.
