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 Control Button (Command15), would automatically export each of these tables to an MS Excel Spreadsheet (each Table is placed into a separate sheet). Attached is my Database and the 6 tables I would like exported are:
The Excel Spreadsheet (Path) is:
ss Table Dump.xlsx
Can anyone help with this one?