Issues with opening DBF (dBase) file in Excel

E

EuroMaverick

Hello people,

I'm pretty sure this question has been asked before a couple of times, but I
cannot find information on this, so please forgive my ignorance:

When I open a DBF-file into Excel, it simply opens right away without any
issues at all. However, all special characters from the DBF-file (e.g. "ë")
have been transformed to something different that cannot be used in Excel.

How can I easily convert this back or even better avoid getting them by
opening a DBF-file ?

Many thanks in advance for any reply !

Benoit Somers.
 
D

Doug Kanter

I'd begin by running charmap.exe Character Map, and seeing if the font
you're using in Excel contains those characters. If not, switch to another
font that does.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format problem from opening dbf file in excel 2007 5
Incorrect date value when open DBF file in Excel 0
Saving Excel file in DBase IV format 9
Cannot open the DBF created from the SaveAs option of Excel 0
Open dbf (ansi) with excel 0
dbf Database 5 file access problem with Excel 4
How do I open a .dbf file in Access 2007? 0
opening a .dbf file in MS Access 5

Top