Applying Criteria in Excel Cell to MS Query Pull from Access

  • Thread starter Thread starter Tony
  • Start date Start date
T

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?
 
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...
 
Back
Top