{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 干净又极端 的问题《Importing DBF files to MS Excel 2007》','https://www.manongdao.com/q-1150044.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.