Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2014, 07:48 PM
shilabrow shilabrow is offline How can I automatically update my spreadsheet with report generated from Access Windows Vista How can I automatically update my spreadsheet with report generated from Access Office 2007
Advanced Beginner
How can I automatically update my spreadsheet with report generated from Access
 
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
  #2  
Old 05-06-2014, 09:08 PM
shilabrow shilabrow is offline How can I automatically update my spreadsheet with report generated from Access Windows Vista How can I automatically update my spreadsheet with report generated from Access Office 2007
Advanced Beginner
How can I automatically update my spreadsheet with report generated from Access
 
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

This is a sample data attached. Any VBA code - Helpppppppp. I need to automatically update my excel file with current updated data from access database as often or monthly once I run the code

Thanks much!
Attached Files
File Type: xlsx sample.xlsx (184.8 KB, 4 views)
Reply With Quote
  #3  
Old 05-07-2014, 01:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How can I automatically update my spreadsheet with report generated from Access Windows 7 64bit How can I automatically update my spreadsheet with report generated from Access Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Have you tried using MS Query?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #4  
Old 05-07-2014, 02:59 AM
shilabrow shilabrow is offline How can I automatically update my spreadsheet with report generated from Access Windows Vista How can I automatically update my spreadsheet with report generated from Access Office 2007
Advanced Beginner
How can I automatically update my spreadsheet with report generated from Access
 
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
  #5  
Old 05-08-2014, 02:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How can I automatically update my spreadsheet with report generated from Access Windows 7 64bit How can I automatically update my spreadsheet with report generated from Access Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Perhaps this link might get you started
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #6  
Old 05-18-2014, 03:59 PM
shilabrow shilabrow is offline How can I automatically update my spreadsheet with report generated from Access Windows Vista How can I automatically update my spreadsheet with report generated from Access Office 2007
Advanced Beginner
How can I automatically update my spreadsheet with report generated from Access
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default

Thanks Pecoflyer. I will go through the link. Should be really helpful, Thanks for sharing this!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I automatically update my spreadsheet with report generated from Access Automatically inserting information into report joughin Word 3 05-15-2012 09:12 PM
How can I automatically update my spreadsheet with report generated from Access replace automatically generated page numbers LitWissOnline Word 3 01-24-2011 03:40 PM
How can I automatically update my spreadsheet with report generated from Access How to set links that automatically update tkelly5446 Project 1 11-17-2010 04:26 AM
How can I automatically update my spreadsheet with report generated from Access Font Problem with Richtextbox in MS Access Report surendrababu Office 2 11-29-2005 02:11 AM
access sub report problem Robbi Young Office 3 08-13-2005 10:47 AM


All times are GMT -7. The time now is 10:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft