Importing data from Excel into a new Table

[Guest]

I'm using Access 2003 SP1.

When I'm in the Tables object area I click on NEW and choose IMPORT TABLE.
The Import window opens, I change the Files of Type to Excel, navigate to
the folder holding the file I want to use, select the Excel file and click on
Import.

In Access 2000, the Import Spreadsheet Wizard opens. In Access 2003, the
Import window closes and ....................nothing else happens. Period.
The system is not frozen, I can move around in Access, but the wizard does
not launch.

Any ideas?

Thanks!

Rob

 

[John Nurick]

Hi Rob,

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.