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!
|