ACC97: Error Message Importing/Exporting/Linking Text Files

• Microsoft Access 97

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

When you use the Export Text Wizard to import, export, or link a text file you may receive the following error message:

   Invalid setting in the Excel Key of the engines section of the Windows
   Registry

RESOLUTION

Use the Registry Editor program, Regedit.exe, to modify a Windows Registry key.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

1. Start the Registry Editor program, Regedit.exe (in Microsoft Windows 95) or Regedt32.exe (in Microsoft Windows NT).

2. Search for the following key:

         HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Text
   

3. Under the Format Key, you will find the following value:

         "DELIMITED()"
   

4. Change the value of the Format parameter to "CSVDelimited" (without the quotation marks). This is a string value and it does not include parentheses.

5. Close the Registry Editor program.