View Single Post
 
Old 05-07-2014, 02:59 AM
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

Hi Pecoflyer,
when you say using MS query - what do you mean. cos I have tried to set parameter in access to give me monthly update of new data however, I still have to manually copy these data to the Excel spreadsheet to update the Excel data with the new updated data from my monthly query. I was just wondering if I could get help in better populating new data from my access directly to my Excel by the use of code and letting the Excel data get updated.

If you have a better idea in getting this work. I will truly appreciate it. Kindly assist me - I need help.

Thanks!
Reply With Quote