Fix Microsoft Access Import Spreadsheet Wizard Showing Old Invalid File Name
Question details
The user is unable to import a new Excel spreadsheet into Microsoft Access because the wizard persistently displays an old file name and cannot clear its reference.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Importing a new Excel spreadsheet data source into an Access database using the built-in wizard.
- Observed behavior
- The Import Spreadsheet Wizard displays a previously used, invalid Excel file name and throws a reference error. This issue persists even after creating new databases, selecting different spreadsheets, and reinstalling Microsoft Office.
Before proceeding with system troubleshooting, verify that the new Excel spreadsheet you wish to import opens correctly in Excel, does not contain corrupted tables, and is not password-protected.
Clear Access User Settings in the Windows Registry
Because reinstalling Office does not always clear corrupted user profiles, resetting the Access registry key removes the cached Import Wizard states.
Microsoft Office applications often cache wizard history and recent file paths in the Windows Registry. If this cache gets corrupted, Access will continue to loop the old file path regardless of the database you open.
Press the Win + R keys on your keyboard to launch the Run dialog. Type 'regedit' into the text box and press Enter. Click 'Yes' if prompted by User Account Control.
In the left pane, navigate through the folder path: HKEY_CURRENT_USER > Software > Microsoft > Office > [Your Office Version number, e.g., 16.0] > Access.
Right-click on the 'Access' folder, select 'Rename', and change its name to 'Access.old'. This forces the application to build a clean settings profile upon the next launch.
Close the Registry Editor and open Microsoft Access again. Attempt to use the Import Spreadsheet Wizard to confirm the old file name has been cleared.
Launch Access in Safe Mode and Disable Add-ins
Third-party add-ins or corrupted startup configurations can interfere with the Import Spreadsheet Wizard. Safe mode bypasses these elements.
Test Import in a New Blank Database
Database-specific configuration corruption can occasionally cause the wizard to recall an old file path. Testing in a fresh database helps isolate the issue.
Looking for a lighter, hassle-free Office suite?
If persistent Microsoft Office configuration errors are slowing down your productivity, consider trying WPS Office. It is a robust, lightweight suite that seamlessly handles everyday document creation, spreadsheet analysis, and presentations without the heavy resource load.
- 1. Download the Installer: Visit the official WPS website to download the free, lightweight installation package for your operating system.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to set up the software in minutes.
- 3. Open Your Files Seamlessly: Launch WPS Spreadsheets and open your existing .xlsx or .csv files directly with zero formatting loss or cached errors.
Frequently Asked Questions
Why does the Access Import Wizard remember an old file name after I deleted the file?
Microsoft Access stores recent wizard states and file paths in the Windows Registry under your specific user profile. If this cache fails to update or becomes corrupted, Access will persistently recall the old file path even if the original file is missing or deleted.
Will reinstalling Microsoft Office fix wizard cache issues?
Not always. Standard uninstallation of Microsoft Office often preserves user-specific configuration files and registry keys to protect your preferences. Because of this, you usually need to manually reset the Access registry key to clear persistent cache errors.
How do I securely back up the registry before resetting Access settings?
Press Win + R, type 'regedit', and press Enter. In the Registry Editor, click 'File' > 'Export'. Select 'All' under the Export range, give the backup file a recognizable name, and save it to your desktop. If anything goes wrong, you can simply double-click this file to restore the previous registry state.
