G
Guest
Does there exist a straightforward method of reaching inside of an Access
database file, from an Excel worksheet, to grab a live Access query? (If
there isn't, I wish that Microsoft would develop it!)
Right now, I can and do export a query from my Access database, which is
saved as a static Excel worksheet file. But, I have to repeat this exercise
every time I want to get the latest versions of the Access database's data.
So, I want a dynamic link instead.
I'm using Office 2003.
(My data will be in Access, because that gives me the flexibility of
ordering it in several different ways using compound keys based on about five
different fields [columns], some of which are non-numeric. My reporting will
be via Excel, because (1) that gives me the flexibility of changing the
details of the report layout "on the fly", and because (2) most of my
colleagues who will use the report interface are comfortable with Excel but
not with Access.)
database file, from an Excel worksheet, to grab a live Access query? (If
there isn't, I wish that Microsoft would develop it!)
Right now, I can and do export a query from my Access database, which is
saved as a static Excel worksheet file. But, I have to repeat this exercise
every time I want to get the latest versions of the Access database's data.
So, I want a dynamic link instead.
I'm using Office 2003.
(My data will be in Access, because that gives me the flexibility of
ordering it in several different ways using compound keys based on about five
different fields [columns], some of which are non-numeric. My reporting will
be via Excel, because (1) that gives me the flexibility of changing the
details of the report layout "on the fly", and because (2) most of my
colleagues who will use the report interface are comfortable with Excel but
not with Access.)