Using A Cell In Excel as Criteria for a Query

[Guest]

Is it possible to use the contents of a cell in Excel as the criteria of a
field in an Access Query? I want to use Excel as an interface and reporting
tool for a data table stored in Access.

For example, in this theoretical interface, I would like to:

On a "parameters" Excel sheet, type a client name in a specific cell

On a "data" Excel sheet, refresh an external data range that is an Access
query that calculates typical metrics for only that specific client name

On a "report" Excel sheet, format the returned data in a presentable way

The major problem that I am having is that I do not know what needs to be
typed in the criteria of a Access query field so that it filters on the text
of a specific Excel cell.

Any help would be greatly appreciated,

 

[Guest]

Debra Dalgleish wrote this in a reply to another message posted here a few
months back. I found both of your messages looking for answers to how to do
exactly what you want. I can't possibly explain it better than he does at
this site.

Nathan

Nick Hodge has information on his site:

http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

 

[Guest]

Thanks, that helps a lot.

Debra Dalgleish wrote this in a reply to another message posted here a few
months back. I found both of your messages looking for answers to how to do
exactly what you want. I can't possibly explain it better than he does at
this site.

Nathan



http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm