Text Table import

[Dext]

I recently loaded my Office 97 version of Access onto my
Windows XP platform. Generally everything seems OK,
however attempts to import comma delimited text files
generate the errror message: "Invalid setting of Excel Key
in Engines section of Windows registry" or words to that
effect. I understand there is a service patch to smooth
the installation of Access 97 on XP -- and I see some --
but I don't see mention of this particular (table import)
issue. What is the collective wisdom on this situation?
Is anyone familiar with a fix for failures of this type?

 

[John Nurick]

Hi Dext,

The first thing I'd try is re-registering the import/export DLL files:

msexcl35.dll (Excel)
mstext35.dll (Text, CSV, tab-delimited))

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder).

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.