Executing a "Saved Import" or "Saved Export" programmatically (1 Viewer)

[ClubSean]

Microsoft goes to great length to explain how to schedule and execute Saved Imports or Saved Exports in Outlook. This implies there is a way to trigger the Imports or Exports programmatically within Access. Anyone know how to do it within Access without using the Wizard? The intent is to execute a Saved Import with button.

Cheers all.

 

[Gasman]

used saved specfications access vba - Google Search

 

[theDBguy]

You could try the RunCommand method.

 

[MarkK]

Private Sub cmdExecuteSpec_Click()
    CurrentProject.ImportExportSpecifications("SpecName").Execute
End Sub