how do I import Excel spreadsheet into Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2002 I could click on File -> Get External Data -> Import to import
(for instance) an excel spreadsheet into Access. A wizard would open asking
questions to set up the Access table. Now in 2003, I cannot get the wizard to
appear and the spreadsheet does not get imported.

Any help is appreciated.
 
Hi Mike,

Usually this fixes it:

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