Cannot Import Excel Tables into Access 97

  • Thread starter Thread starter Sefton Area
  • Start date Start date
S

Sefton Area

I have a PC running Windows XP Pro, which has Microsoft Office Professional
97 SR2, loaded.

In Access 97, when trying to Import data it does not show in the drop down
menu the option to Import from Microsoft Excel, HTML Documents, Lotus 1-2-3,
and Text Files

Actions taken are

? Uninstalled, and re-installed MS Office Pro 97 several times, but without
success.

? Installed the ODBC drivers from the ValuPack, using the advice contained
in MS Article: 156835.

? Checked that the correct version of Accwiz.dll is installed per MS
Article: 303804

How can I solve this problem? I need to Import Excel Tables into Access!
 
I suppose you have selected complete install.

Did you also follow the steps of this article

so regsvr32 <path>\Accwiz.dll ?

- Raoul
 
Hi,

I don't know how to fix your import excel wizard, but I do know a workaround.

You could go into your Excel table and "Save As" your file as a comma
delimited text file.

You could then import the comma delimeted text file you just made if your
import text wizard works.
 
Sefton said:
In Access 97, when trying to Import data it does not show in the drop
down menu the option to Import from Microsoft Excel, HTML Documents,
Lotus 1-2-3, and Text Files
Click to expand...

Reregister the dll files

Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll
 
Sefton Area said:
I have a PC running Windows XP Pro, which has Microsoft Office Professional
97 SR2, loaded.

In Access 97, when trying to Import data it does not show in the drop down
menu the option to Import from Microsoft Excel, HTML Documents, Lotus 1-2-3,
and Text Files

Actions taken are

? Uninstalled, and re-installed MS Office Pro 97 several times, but without
success.

? Installed the ODBC drivers from the ValuPack, using the advice contained
in MS Article: 156835.

? Checked that the correct version of Accwiz.dll is installed per MS
Article: 303804

How can I solve this problem? I need to Import Excel Tables into Access!
Click to expand...
 
Back
Top