Applying Criteria in Excel Cell to MS Query Pull from Access

[Tony]

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?

 

[Jim Thomlinson]

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