I have a similar question. The Get External Data works fine from my
computer, but is it possible for the embedded query to remain connected to
Access, if the .xls is stored in a shared drive folder, and linked to by a
hyperlink/URL from the corporate intranet page? As far as I can tell that
removes the auto-refresh/link to the Access data, or am I missing something
somewhere? Everyone is using Excel 2003, Access 2003 and do not have
SharePoint where I work. They don't want to use DataAccess Pages.


"Jim Thomlinson" wrote:

Sure you can use VBA to do that, but why not just use Get External Data and
embed a query in your spread sheet. It is a lot easier than going the VBA
route (unless you have good reason to do so). If you need to to go the VBA
route reply back and I can give you some code. I am assuming that you know A
little bit about Access...

"JonR" wrote:

Hello,

I've developed an Access database that tracks service requests and when they
are opened, closed, or if and when they are canceled. I would like to
summarize this in an Excel chart such as number of requests opened and closed
by month, but would rather not import the entire data table to perform this
calculation.

Is it possible to query the data table as it resides in Access so all I have
to pull over is a few summary numbers?

TIA
Jon