Fix Missing Run Saved Import/Export Action in Microsoft Access
Question details
The user is unable to find the Run Saved Import/Export action while working in the Macro Editor of Microsoft Access.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Creating or editing macros in Microsoft Access and attempting to add an import or export command to Excel or other formats.
- Observed behavior
- The Run Saved Import/Export macro action is missing or hidden from the available commands list by default in the Macro Design view.
Ensure you have already manually created and saved an import or export specification in your Access database before attempting to automate it via a macro.
Enable Show All Actions in Macro Design View
Unhide all available macro commands, including the Run Saved Import/Export actions, by toggling the display settings in the Macro Editor.
Microsoft Access does not display every macro command by default to keep the interface clean and prevent accidental use of advanced functions. The Import/Export to Excel commands are among those that are initially hidden.
Open your Access database, right-click the macro you want to edit in the Navigation Pane, and select 'Design View'.
Look at the Ribbon under the Macro Design tab, or check the right side of the Macro Editor window.
Click on the 'Show All Actions' button. This will force Access to display all hidden commands.
Click the 'Add New Action' dropdown list. You should now be able to search for and select 'RunSavedImportExport' from the list of available commands.
Try WPS Office for Your Document and Spreadsheet Needs
While WPS Office does not include a database management tool like Microsoft Access, it offers a powerful, free, and lightweight alternative for your daily document, spreadsheet, and presentation tasks. It is fully compatible with Microsoft Office formats, making it easy to manage your exported Access data.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Open Exported Data: Use WPS Spreadsheet to seamlessly open and analyze the data you exported from Microsoft Access.
- 3. Save and Share: Save your edited spreadsheets in standard formats like .xlsx to ensure complete compatibility with Microsoft users.
Frequently Asked Questions
Why does Access hide certain macro commands?
Microsoft Access hides certain macro actions by default to simplify the interface for casual users and prevent them from accidentally executing advanced or potentially unsafe system commands.
How do I save an import or export specification in Access?
Before using the RunSavedImportExport macro, you must manually perform the import or export once. On the final step of the Import/Export Wizard, check the box labeled 'Save import steps' or 'Save export steps' and provide a name for the specification.
Can I run a saved export directly without building a macro?
Yes. You can run saved imports and exports manually by navigating to the External Data tab on the Access ribbon and clicking on 'Saved Imports' or 'Saved Exports' to execute them immediately.
