I have a query in Access that pulls information from a remote database. I then put that data into a local table and export that table to excel. I have a workbook that has a spreadsheet setup to get it's information from the information exported table. I want to be able to export the data from Access to the exsisting workbook, just a different sheet. Below is the code I was using to export the table.
Public Sub Export()
DoCmd.OutputTo acOutputTable, "Canceled Table", acFormatXLS, "M:\Updated Cancel Reports\Canceled.xls", False
End Sub