Query parameters
 

Dear All,

I am about to import data from an odbc data source into excel worksheet
using msquery. When I use a simple query from one table I can set up
parameters for the query, but when I build a query using multiple joined
tables / what I really need / the possibility of setting up a parameter
disappears (the button is there but I press it in vain). Why ? Can someone
tell me how to use parametrized query and what are the requirements of such
query ? Also, how can I use a stored procedure to retrieve data when the
procedure has a parameter ?

Regards,
Laszlo