ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Issues with opening DBF (dBase) file in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/71793-issues-opening-dbf-dbase-file-excel.html)

EuroMaverick

Issues with opening DBF (dBase) file in Excel
 
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.


Doug Kanter

Issues with opening DBF (dBase) file in Excel
 
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.


"EuroMaverick" wrote in message
...
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.





All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com