Unable to import Excel files to Access 97

  • Thread starter Thread starter JohnL
  • Start date Start date
J

JohnL

When I try and import an Excel file into Access 97, Excel
is not one of the choices made available, Paradox and
Lotus 123 however are available. I have reinstalled Office
97 pro and did the custom install, selecting all of the
data access drivers. I also installed the value pack but
still no luck. I don't use Lotus but the person who had
this computer before me did.

Any help would be much appreciated.

John
 
Hi John,

The usual cure is:

If the import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re-register the
following files
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

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.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881
 
-----Original Message-----
Hi John,

The usual cure is:

If the import/export wizards don't work at all, re- register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re- register the
following files
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

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.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881
When I try and import an Excel file into Access 97, Excel
is not one of the choices made available, Paradox and
Lotus 123 however are available. I have reinstalled Office
97 pro and did the custom install, selecting all of the
data access drivers. I also installed the value pack but
still no luck. I don't use Lotus but the person who had
this computer before me did.

Any help would be much appreciated.

John
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Hi John,
Click to expand...

Thank you, that did the trick.

John
 
Back
Top