Link query to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Ricoy-Chicago said:
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.
Click to expand...
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.
 
DanielS via AccessMonster.com said:
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.
Click to expand...

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.
 
Back
Top