You need to add a prompt into your MS Query. Open MS Query and add a promt to
the appropriate field. [Enter Location] as an example. Now exit back to
excel. Now under Data - Import External Data the parameters menu itme should
be enabled... Follow the wizard from there...
--
HTH...

Jim Thomlinson


"Tony" wrote:

I am running an MS Query in Excel using the Create New Database Query
Function pulling data from an Access Database Table. In one of the
cells, I have the criteria for the Query. How do I have MS Query grab
the criteria from the Excel cell and include it in the list of
criteria that it pulls in from Access?