Using A Cell In Excel as Criteria for a Query

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,

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/datam...taexamples.htm



"Charles" wrote:

> 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,

Thanks, that helps a lot.


"Nathan" wrote:

> 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/datam...taexamples.htm
>
>
>
> "Charles" wrote:
>
> > 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,