Report produced in access and linked/updated in excel

[Guest]

I have created an Access database with linked reports. I need to use these
reports both format wise as well as to produce graphs from in Excel. As the
people who will be using this information are not tech savvy I am trying to
automate the process as much as possible. I already have the subsequent
excel graphs, manipulations and PowerPoint presentations basically set-up.
Those portions are all designed to update the data from each other.

At the same time the access database is set up so if a change is made in the
main database the changes are reflected all the way to the desired reports.

The problem I am having is that I want the access report format/data to be
linked to the initial excel workbook and if a change is made in the access
database the change is reflected the next time the Excel work book is opened.

The final idea is that the user only needs to enter a new datum once in
Access and the Access reports, Excel pivots, Excel graphs and PowerPoint
presentation will all be updated automatically on opening.

Thanks in advance for any assistance in this endeavor


The problem i am having is that I want the access report format/data to be
linked to the initial excel workbook and if a change is made in the access
database the change is reflected the next time the excel work book is opened.

The final idea is that the user only needs to enter a new datum once in
access and the access reports, excel pivots, excel graphs and power point
presentation will all be updated automattically on opening.

Thanks in advance for any assistance in this endevor

 

[John Nurick]

Hi Ken,

As you have probably found, there are all sorts of complications with
exporting formatted Access reports. In the situation you describe I'd
be inclined to have Excel extract the data by running queries against
the Access database (either by VBA code using the DAO or ADODB
libraries, or using the worksheet database features). Updating could
be triggered automatically (e.g. in the workbook's Document_Open
event, whatever it's called) or by user action.

On Thu, 11 Oct 2007 13:12:03 -0700, Ken DeYoung - Educational
Consultant <Ken DeYoung - Educational