Link query to Excel

[Guest]

I want to link data from a table to an Excel worksheet. I have used Data, Get
external data, New database query, etc. However I want to import only certain
records but not using the boxes in the Excel wizard but more like a parameter
query in Access where the user can select certain data only. Can I do the
same in Excel? or, Can I import my parameter query directly into Excel?

By the way, if the data changes in Access is the Excel worksheet updated?

I am using MS XP

Thank you for your help.

 

[DanielS via AccessMonster.com]

I want to link data from a table to an Excel worksheet. I have used Data, Get
external data, New database query, etc. However I want to import only certain
records but not using the boxes in the Excel wizard but more like a parameter
query in Access where the user can select certain data only. Can I do the
same in Excel? or, Can I import my parameter query directly into Excel?

By the way, if the data changes in Access is the Excel worksheet updated?

I am using MS XP

Thank you for your help.

You can create a set of criteria in the MSQuery, afterwards thesee criterias
can be link to cell containing the value to filter the data. When access data
changes you need to refresh in Excel.

 

[Guest]

You can create a set of criteria in the MSQuery, afterwards thesee criterias
can be link to cell containing the value to filter the data. When access data
changes you need to refresh in Excel.

Dear danielS:

I figured out that much about the MS Query. Stupid Q. how do I link criteria
from the query to the cell? Also I need to create a pivot report based on the
query result, as the data changes in Access the Excel data updates OK,
however, the pivot report does not update! (grrrr...) any hints about this
one.

Thanx.