how do I import Excel spreadsheet into Access 2003?

[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.

 

[John Nurick]

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.

 

[Guest]

John,
Thank you for your timely response.

Mike B