I have an ACCESS query that can't ODBC with Excel because one parameter
of the query needs to be specified before the query can be ran.

For instance, if I put date=7/15/2005 as the criteria in ACCESS query
and then in excel 2003, I go to data->import data->select the query.
The ODBC will work.

Then I changed the query so that the criteria is not a static value,
instead, ACCESS will pop out a window asking for "What date do you
want?" and then the query will return some result.

The change will destroy the ODBC connection. There is an error message
saying "too few parameters" blah blah....

My question: how to ODBC an ACCESS query that needs to specify a
parameter in the query?