importing Excel spreadsheets into Access 2002

  • Thread starter Drew via AccessMonster.com
  • Start date
D

Drew via AccessMonster.com

We're having a strange issue where when user want to import an .xls file into
Access, the available filetypes aren't listed in the drop down box. There
are other users who have that option in the same version (2002) of MS Access.

Any thoughts?

Thanks in advance.
 
J

John Nurick

Hi Drew,

This usually fixes it: If the import/export wizards don't work at all,
or if you get "No object in this control" 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.
 
Top