Display Access query as Excel file

[Shodan]

Hi,
Is there any way to display the results of an Access
2000 query as an Excel 2000 worksheet? The data should
have the ability to be refreshed from Excel.

I know you can create queries in Excel using MS Query and
linking to an Access database, but this particular query
is quite complex with calculations and several joins, and
MS Query apparently does not allow Outer joins on more
than two tables.

So I wanna know if I can just instruct Excel to use a
query already created in an Access database I have linked
to. Thanks.

Shodan

 

[Douglas J. Steele]

I would assume that Excel 2000 would be similar to Excel 97 in this regard.
Use Tools | Get External Data, and point to the query in question.

Once you've set it up, right-click on the results give you an option to
Refresh the data. I'm sure it's possible to do programmatically as well, but
I didn't bother checking.