This page was helpful to me when I was trying to use parameters for the
first time. Hope it helps you too.

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
Carlos

"Lac" wrote in message
...
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