Excel file type missing in import / export window

  • Thread starter Thread starter Quock D
  • Start date Start date
Q

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