Display MS Access Query in Excel



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.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads