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

 

[ClubSean]

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

Many Merci's, Mark

 

[MarkK]

Beaucoup bienvenue.

 

[azhar2006]

'Export
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Name Query", "D:\AZ.xlsx", True

'Import
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "Name Query", "D:\AZ.xlsx", True