Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can use the RunSavedImportExport macro action in Access desktop databases to run a saved import or export specification that you created by using the Import Wizard or the Export Wizard.

Note: This action will not be allowed if the database is not trusted.


The RunSavedImportExport macro action has the following argument.

Action argument


Saved Import Export Name

Select the name of a saved import or export specification from the drop-down list.


  • This macro action has the same effect as performing the following procedure in Access:

    1. On the External Data tab, click either Saved Imports or Saved Exports.

    2. In the Manage Data Tasks dialog box, on the Saved Imports or Saved Exports tab (depending on your choice in the preceding step), click the specification that you want to run.

    3. Click Run.

  • Before running the RunSavedImportExport action, make sure that the source and destination files exist, the source data is ready for importing, and that the operation will not accidentally overwrite any data in your destination file.

  • If the saved import or export specification you choose for the Saved Import Export Name argument is deleted after the macro is created, Access displays the following error message when the macro is run:

    The specification with the specified index does not exist. Specify a different index. 'specification name'.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!