This article explains what to do if OEM font special characters don't display correctly in Microsoft Access or Excel.
Problem:
When reading from a file in which data was written using OEM font information (usually from an old DOS character-based system), special characters like $ and £ do not display correctly in Microsoft Access and Excel. The special characters display correctly, however, when using the AcuXDBC utilities asql or odbcsql. Previously, AcuODBC had an option that allowed the character set to be chosen (ANSI or OEM); this option is not available in AcuXDBC.



