1. The following example exports the data from the Microsoft Access table External Report to the delimited text file April.doc by using the specification Standard Output:

DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"


2. The following example exports the data to Excel spreadsheet Newemps.xls from the Microsoft Access Employees table.
DoCmd.TransferSpreadsheet acExport, 8, _
"Employees","C:\Excel\Newemps.xls"