Display MS Access Query in Excel

S

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
 

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

Adding data to MS Access from csv file 0
urgent help- access to excel 1
Autonumber field in Excel that behaves the same as Access 0
parent child link query 1
outer joint query 1
Viewing files content inside MS-Access form 1
Access Query to import from Sharepoint 0
Display Access query as Excel file 1

Top