I cannot import an Excel spreadsheet into Microsoft Access...I get the following error message

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

When I follow the instructions for finding disabled items it tells me that I don't have any disabled items. I have uninstalled Microsoft Office completely and reinstalled it but still have the same problem. Does anyone have a solution to this?

Thanks

Hi,

Do you mind telling us which Office's edition do you use? Office Home & Business 2013, Office Professional 2013 or other?

Based on the error message, this issue might be caused by this scenario: A copy of Microsoft Access 2013 stand-alone version is installed on a machine where a Microsoft Office 2013 Professional suite is installed and during the installation of Microsoft Office 2013 Professional, Access was set to "Not Available." If yes, please try the following methods:

1. Remove the stand-alone installation of Microsoft Access 2013.
2. Add Access from the Office Professional 2013 installation.

If no, we also can check that your wizard folder is in a trusted location:

1. Go to the Trust Center by Clicking on File ->Access Options->Trust Center->Trust Center Settings->Go to Trusted Locations
2. If the path C:\Program Files\Microsoft Office\Office15\ACCWIZ is not listed under the User Locations, add it as follows:
3. Click Add New Location->Browse->Go to the folder C:\Program Files\Microsoft Office\Office15\ACCWIZ.
4. Close out of the Trust Center, exit Microsoft Access and then reopen it.

Hope it's helpful.

Regards,

Thanks,

The Trust Center Trusted Location option worked for me...it just took me awhile to find the ACCWIZ folder as it was in a different location than listed above...buried in multiple folders.

I had to do "C:\Program Files\Microsoft Office 15\root\Office15\ACCWIZ"

I have the Microsoft Office 365 University 2013 edition, so maybe that's why the route is slightly different. Once I found it everything worked properly though.

Thanks again,

Rachel