My Excel import isn't working with Access 2000

[Michael]

When I go into Access 2000 and select File > Get External
Data > Import and select an Excel file, I get an hourglass
for a fraction of a second, and then no import (or error
message). These same Excel files import perfectly into
Access 97. Any ideas?

 

[John Nurick]

Hi Michael,

Most problems of this kind seem to be caused by problems in the Windows
registry.

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
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

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.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881

When I go into Access 2000 and select File > Get External
Data > Import and select an Excel file, I get an hourglass
for a fraction of a second, and then no import (or error
message). These same Excel files import perfectly into
Access 97. Any ideas?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.