Text that uses umlaut characters may not correctly import in Office Access 2003

Consider the following scenario. You try to import a file into a Microsoft Office Access 2003 database as a new table by using the Text Import Wizard. If the data in the file contains text that uses the following umlaut characters, these characters may not correctly import into Access 2003:

• ��
• ��
• ��

This issue occurs when the default code page for the Text Import Wizard is not set to Unicode (UTF-8). When a different code page is selected, the umlaut characters may be mapped to different characters.

To resolve this issue, follow these steps:

1. In Access 2003, click Table in the Objects pane of the database window.
2. Click New on the Database toolbar.
3. In the New Table list, click Import Table, and then click OK.
4. In the Files of Type list, click Text file (*.txt, *.csv, *.tab, *.asc).
5. Locate and then click the source file that you want to import in to the database, and then click Open.
6. Click Advance.
7. In the Code Page list, click Unicode (UTF-8), and then click OK.
8. Click Finish to import the table.