Is there a way to use MS Query to lookup a range of values from a
spreadsheet? Currently we use an excel front end to let users query
an access db - ms query allows them to enter a value into the
parameter window. I'd like to be able to pass a list of values -
rather than doing this one at a time.

The whole process for the end users has been simplified to pushing a
button - fyi.


Thanks much.