Excel file type missing in import / export window

[Quock D]

I was able to import or export from Accessm to Excel.
Recently someone tried to fix something on my PC, after
that I lost this capability; i.e. when I try to import an
external file (from Access), on the file type dialog drop
down list, I only see *.mdb, not *.xls, not .txt, etc.
Same problem for exporting.

Any suggestion to correct this problem? Thanks.

 

[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
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

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.