ACC97: Error Message Importing/Exporting/Linking Text Files (163280)



The information in this article applies to:

  • Microsoft Access 97

This article was previously published under Q163280
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.

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

SYMPTOMS

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. This is a string value. It does not have parentheses.
  5. Under the Extension Key, make sure you see the following value:

    "txt,csv,tab,asc"

    NOTE: This string has no spaces in it.
  6. Close the Registry Editor program.

Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kberrmsg kbprb KB163280