Cannot Import Excel Tables into Access 97

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!
 
J

JaRa

I suppose you have selected complete install.

Did you also follow the steps of this article

so regsvr32 <path>\Accwiz.dll ?

- Raoul
 
S

Sefton Area

Yes. I have tried full install, and regsvr32 <path>\Accwiz.dll without
success.
 
B

BDM

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

Joan Wild

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
 
B

bai

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot access to Office Insider 0
Compile error in table level validation expression in ms access office 2019 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Weird problems installing Access 97 on WIndows 2000 Profressional 3
Access 97 Gurus? 17
Unable to create table using Access 97 3
Keep Excel Sort on Table Import 2
Excel 2010 Table not showing in Access 2010 Import List 0

Top