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


The information in this article applies to:

  • Microsoft Office Access 2003

SYMPTOMS

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:
  • Ää
  • Öö
  • Üü

CAUSE

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.

RESOLUTION

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.
Modification Type:MajorLast Reviewed:5/18/2005
Keywords:kbwizard kbtable kbDatabase kbImport kbtshoot kbprb KB899600 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.