DoCmd.RunSavedImportExport method (Access)
Run a saved import or export specification.
Syntax
expression.RunSavedImportExport (SavedImportExportName)
expression A variable that represents a DoCmd object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| SavedImportExportName | Required | Variant | The name of a saved import or export specification to run. |
Remarks
This method has the same effect as performing the following procedure in Access:
On the External Data tab, choose either Saved Imports or Saved Exports.
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.
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for