Microsoft Access can't find the wizard.

Anonymous
2010-09-27T03:19:50+00:00

Getting the error: Microsoft Access can't find the wizard. etc...

Occurs when: Using the Import from Excel feature

I have checked the Add/Remove Features and Access is completely installed, not sure what is missing?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

83 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-11-24T15:25:36+00:00

    Hello Gina,

    I know this thread is old now but my version of Access has just developwed this problem.

    This thread tangents off into outlook later by the sound of it, my issue is with the import of external data from Excel to Access - I am getting the error messages:-

    1)The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project

    1. **Microsoft Office 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 Microsoft Office Button, and click Access Options. Click Add-Ins, and then in the Manage list, click Disabled Items, and then click Go. Rerun Microsoft Office Access or Microsoft Office Setup program to reinstall the wizards. If the missing wizard is not a Microsoft Office Access wizard, reinstall it using the Add-in Manager.

    Apparently this is an issue MS have been made aware of in the past.

    Earlier this week and since the installation of Office 2010 over a year ago this problem hasn't been apparent, the only change that has happened to my standalone PC is 'Updates' which have occurred this week automatically.  I imported a number of excel datasheets into this access db file on Monday this week (21st Nov 2011).

    I am unable to find a solution which works, I have currently tried:-

    • Repair Access install
    • MS Office
    • rename extensions of wizards in ACCWIZ folder & Repaired MSOffice
    • renamed VBA7 folder & Repaired MSOffice

    Do you have a deffinitave fix for this problem, it looks like whatever this week\s update was has caused the issue????

    Cheers Mat

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-10-19T10:14:51+00:00

    Hi,

    The .pst Name property should have atleast 16 characters.

    In Outlook File- Info- Account-Settings - Account Settings- Data Files- Select the pst file and click Settings - change the Name: to atleast 16 characters- Apply - Ok.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-10-19T10:09:27+00:00

    Hi,

    The .pst Name property should have atleast 16 characters.

    In Outlook File- Info- Account-Settings - Account Settings- Data Files- Select the pst file and click Settings - change the Name: to atleast 16 characters- Apply - Ok.

    Regards

    Abdul Muneem Khan

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-07-17T02:26:11+00:00

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-07-17T02:23:38+00:00

    Okay I have not had any issues with that...  Have you tried running Repair Installation?

    Was this answer helpful?

    0 comments