Microsoft Access can't find the wizard, or there is an incorrect setting in the windows registry.

I have a user that is on a windows XP pro Sp 1 machine using access 97. MS office 97  and Ms office 2000 ( no access or front page installed ) on the machine. When trying to import an excel sheet into the database, I get an error saying: "microsoft access can't find the wizard, or there is an incorrect setting in the windows registry. Rerun microsoft acces or miscrosft office setup to reinstall the wizards. If the missing wizard is not a microsoft access wizard, reinstall it using the add-in manager."

I have uninstalled both aps variou stime and have looked at MS KB information and was unable to correc thtis problem. Now After reinstalling access for the 5th time I tried to import an excel sheet but I would not select execel as a file type in my drop down list. Please help.

Solution: Microsoft Access can't find the wizard, or there is an incorrect setting in the windows registry.

Hello,

I'm sorry I don't have the quick patch to make it work. I have had this problem numerous times, and the only (painful) solution is... reinstall.

However, you need to install in the chronological order:
* remove both versions of office
* make sure you delete the folder(s)
* make sure you remove the office folders from the users settings
* remove all you dare from the registry...

* Install Office 97, in a non-default folder. Probably only Access and Excel.
   [e.g. C:\Program Files\MSOffice 1997]
* check that you can import
* if not look at the "data drivers" options of the installation and add Excel drivers
* apply patches

* Install Office 2000 in another folder
   [e.g. C:\Program Files\MSOffice 2000]
* apply patches

I could never fix an Office 97 installation if Office 2000 was present. Very annoying.

Hope this helps!
(°v°)