Microsoft Access can't find the wizard.

Programs and Features > Microsoft Office > Change > Add or Remove Features:

Using plus arrow beside Microsoft Access and Microsoft Excel to ensure all sub features are set to: Run from My Computer

And then...

Programs and Features > Microsoft Office > Repair

Still the same issue after Repair and reboot.

Sorry, I meant the steps you are using to do the import.

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

1. Create a new blank db
2. External Data
3. Import & Link -> Excel
4. Browse and select .xlsx file
5. Select Import the source data into a new table in the current database.
6. Click OK
7. Error comes up:

Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled.

To reenable this wizard, click the File tab, and click Access Options. Click Add-Ins, and then in the Manage list, click Disabled Items, and then click Go. Rerun Microsoft Access or Microsoft Office Setup program to reinstall the wizards. If the missing wizard is not a Microsoft Access wizard, reinstall it using the Add-in Manager.

I have check the disabled Add-Ins and there are none.

Well, it definitely sounds like your wozards are corrupt...  This is UNTESTED...

1. Navigate to foler Program Files (for Windows 7 64 bit it's Program Files (x96)
2. Then folder that holds Microsoft Office 2010 (or what ever you named it)

3.  Then Office 14 - ACCWIZ

4.  Change the extensions to .OLD

5.  Repair/Reinstall Office making sure you have those optons seleccted

6.  Try again

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

1. Renamed ACCWIZ folder
2. Renamed ACCWIZ.DLL
3. Repair
4. Confirmed that ACCWIZ folder and ACCWIZ.DLL were reinstalled

And no luck, same error as before.