How can I automatically update my spreadsheet with report generated from Access

[shilabrow]

How can I update my spreadsheet with report generated from Access monthly. I have a report that I run in access monthly. Every month, I go to the database and copy ALL data including the old and current one and paste in my excel worksheet to work on. I however want to use the parameter criteria by month to just extract monthly update and only add that portion to my existing old EXCEL spreadsheet instead of copying ALL data to date over and over.



MY QUESTIONS IS - Is there is a way to just extract the updated monthly data from access and automatically add to to my current Excel Spreadsheet to get an updated version. This is because I have a set up Model Excel spreadsheet where new data will dynamically update and the report reflecting the updated data.

Any help will be appreciated. Thanks!!