Applying Criteria in Excel Cell to MS Query Pull from Access
 

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?

Applying Criteria in Excel Cell to MS Query Pull from Access
 

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?