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.
Setting
The RunSavedImportExport macro action has the following argument.
|
Action argument |
Description |
|
Saved Import Export Name |
Select the name of a saved import or export specification from the drop-down list. |
Remarks
-
This macro action has the same effect as performing the following procedure in Access:
-
On the External Data tab, click 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), click the specification that you want to run.
-
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'.
