Using A Cell In Excel as Criteria for a Query

#1 (**permalink**) 28-Jul-2006, 08:34 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13105-using-a-cell-excel-criteria-query.html

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13105

Any help would be greatly appreciated,

#2 (**permalink**) 28-Jul-2006, 08:34 AM

If I remember correctly, what you seem to be looking at is really a
question of creating a "LinkQuery" from Excell into an Access Table.

All of that is done from within Excell and you would change the value
on the tab and then refresh the link from within Excell. I have done it
but it has been a number of years now since I did it.

This is not putting any new data into Access but simply pulling queries
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13105
of data from an Access MDB.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13105

Good Luck.

Ron