I'm using Microsoft Access 2013 over a network.
There is an option in Access that allows you to export data from a query into an Excel file using a wizard. This option works fine for me. However, after the export, I would like the option to return later and append data to that same Excel file.
In other words, let's say the data exported looked like this:
I want Access to bring up this same query at a later date with updated information and append it to that same Excel file. So if the most recent data added to the table/query included "Elephant" and "Snail", the same Excel file will now look like this:
Is there a way to do this using the current Access options, or does it have to be done another way somehow?