Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS query--can it handle parameter queries from Access?
I'm trying to use Excel and MS Query to return data based on a parameter
query made in Access. When I try to run the MS Query function I get an error "too few parameters. Expected X" where X is the number of parameters designed into the query in access. I guess I assumed MS Query would show a pop up window for the user to enter the relevant parameter, as is done in Access. Is this a limitation of MS Query? Or are these types of queries more properly designed within the MS Query query design tool? Thanks. Dave -- Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
import data from an Access parameter query | Excel Discussion (Misc queries) | |||
Renaming Access Query used by Excel | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |