DoCmd.RunSavedImportExport method (Access)

Run a saved import or export specification.


expression.RunSavedImportExport (SavedImportExportName)

expression A variable that represents a DoCmd object.


Name Required/Optional Data type Description
SavedImportExportName Required Variant The name of a saved import or export specification to run.


This method has the same effect as performing the following procedure in Access:

  1. On the External Data tab, choose 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), choose the specification that you want to run.

  3. Select Run.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.