What you posted was not a stored procedure, it was just inline SQL. Of course that can be incorporated in an SP, but an SP needs a definition (such as the name that will be used when executing it, and any parameters), and the execution needs to be defined, as I assume that you won't invoking it from SSMS or the Access client. What you asked for is so trivial, I assumed that you were asking how to pass that parameter in a call from Excel. From your answers, and the page that snb directed you too,it appears that you do not mean a database at all, Excel is NOT a database, at best it is a (poor) data container, and doesn't support stored procedures.

Why you posted that SQL is beyond my comprehension.