Trouble importing excel spreadsheets

[Dion Jones]

I am trying to import excel 2000 spreadsheets into access
2002 which I have done lots of times before on this machine.

all of a sudden it comes up with a message saying that,

"SIT Product Manager cannot find the wizard. This wizards
has not been installed, or there is an incorrect setting in
the windows Registry, or this wizard has been disabled."

where 'SIT Product Manager' is my database.

I've uninstalled access and office and reinstalled them to
no avail. the wizard is not disabled either.

help appreciated.
Cheers,
Dion

 

[John Nurick]

Hi Dion,

Try this: 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

 

[Guest]

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Hi,

Tried all that. still no joy.
It looks like when I uninstall it it's still leaving some
values somewhere because my recent file list is still there
when I re-install access 2002.
It registers the DLLs fine again, but then just says the
same message as before.

Any more suggestions?

Dion