Linking to External Documents

[Kevin Hume]

I have quite a complex database and need to export some data from it into
excel, I've set up a table in excel with links to two seperate tabs, in
these, I would like to have data from two access queries automatically
feeding in (so that when the user goes into the file, the data is live and
accurate)

anyone know if this is even possible, and if so how to carry it out?

 

[Pete D.]

This would probally be easier to do from Excel using Access as the source
data. Pretty much a standard thing to use Excel to
Analyze external data from various sources. I think you would do better
posting this idea to an Excel group and working from excel.

 

[Tom Wickerath]

Kev,

Not Possible

Wrong answer. It is very possible, as Pete D. indicates. You can have VBA
code in the Excel spreadsheet that queries (pulls) in the latest data
whenever the spreadsheet is opened and/or by clicking a command button within
the Excel spreadsheet to force a refresh of the data.

The how-to's as far as setting this up are best asked in an Excel newsgroup.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[david]

Surprised if you need VBA: can't you write data source or DDE
information directly into the cell?

But shows how little I know. Agree that Excel group is best place
to ask.

(david)

 

[Pete D.]

Your right, I just don't do a lot of importing repeat data from access other
then conversions which are one time kind of things, usually tweaking the
data. I do pull radio and meter things in from the serial port but again
this is kind of specific to situation. Excel folks do it all the time.
VBA/VB and DDE info is available but the Excel folks would have the key for
this.

 

[Maarkr]

this may help:
talks about SQL in Excel and connecting to Access.
http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeConn