When you say you want parameters, do you mean for a stored procedure, or
just a straight SQL query with a few where clauses?

There's a routine I posted here that shows how to run a parameterised stored
proc.

http://groups.google.com.hk/group/mi...2dd1dee?hl=en&

Robin Hammond
www.enhanceddatasystems.com

"Nodak" wrote in message
...
I have used Parameters w/ ODBC MS Query, but would like to use Parameters
with an OLE connection to SQL Server... does not seems to work gives error
"No Value Given for one or More Parameters"

Ideally it would be great to refer to a Excel Range name in the OLE Query
to
get the Paramaters.

Thanks in Advance