View Single Post
 
Old 05-06-2014, 07:48 PM
shilabrow shilabrow is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default How can I automatically update my spreadsheet with report generated from Access

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!!
Reply With Quote