I'm experimenting with getting Access to push stuff in and out of Excel using the following code behind two buttons ...

Code:
Private Sub ExportContacts_Click()

    'transfer the table CONTACT to the spreadsheet ContactSpSheet

    DoCmd.TransferSpreadsheet acExport, , "CONTACT", _
            "C:\Users\Owner\Documents\ContactSpSheet"

End Sub

Private
...