| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel pull data out of access? | Setting up and Configuration of Excel | |||
| Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Pull down cell to access n&a spreadsheet | Excel Worksheet Functions | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
