Lost .xls extension for Exporting

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

I re-installed '97 and have now lost the ability to export
to Excel. Have tried to re-install, but the Data Access,
Change Options is disabled, says it's installed, but Excel
is still not available as an export file type. Any help
appreciated... thanks
 
Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.
 
Found this on another thread... thank you John Nurick!

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
 
Back
Top