NEW! MS Access 2013: I have a database with 6 tables. It would be very useful to me if I could get a code that, upon the click of a Form’s Control Button, would automatically export each of these tables to an MS Excel Spreadsheet (each Table is placed into a separate, same name sheet).
It is very important, though, that the exported data always goes to the same Spreadsheet with the same Sheets (they have already been created)—and simply over-writes any data that may already exist in the Excel Sheets. This is because there is another Excel Spreadsheet that has formula’s attached to each sheet within this one).
Attached is my Excel Spreadsheet along with my Access Database. The 6 tables I would like export are:
The Excel Spreadsheet (Path) is:
ss Table Dump.xlsx
Can anyone help with this one?