pass parameter to access query

Jamie Collins wrote:
You can most definitely *execute* a Jet (MS Access) stored procedure
(stored Query) using MS Query in Excel without VBA code.


OK.
Thanks for the clarification.
I must give it a whirl.
Pity my clients are all 2002 at latest....but one day...

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill Manville wrote in message

Pity my clients are all 2002 at latest

Why?

You can *create* the procedure within MS Access using the PROCEDURE
syntax e.g. I just tested your example

PROCEDURE MyProc [argSiteID] INTEGER;
SELECT * FROM Sites WHERE Sites=argSiteID

in Access95 and it works fine and will work for all subsequent
versions of MS Access.

You can *call* the procedure within MS Query using ODBC's call syntax.
Again, tested fine in Excel95 and above.

Jamie.

--