title: Exporting a Table from Access to Excel based on the click of a command button
body: <p>I am trying to find a way to allow a user to automatically have a certain table from an access database to export to an excel sheet based on the click of a command button on a form. After the table has been exported I want the excel sheet to automatically pop up. But I have other tabs that are already on the spreadsheet so is there a way to allow the table to only be exported to that one tab and have it automatically update when the user presses the command button. I have tried to make the command button using the macro so I wouldnt mess up the coding. I usually code VBA but I am stumped on this. Thanks so much!</p>