CopyObject Method
DoCmd Object
Save Method
TransferDatabase Action
TransferSpreadsheet Method
TransferText Method
Use the MSysConf table in a Microsoft Access database with linked SQL databases
Recordset Object (ADO)