SQL stored procedure with paramters from MS Query

J

JimF

Is it possible to call a SQL stored procedure with parameters that come from
a worksheet cell using MS Query?
 
J

JimF

Carlos,

Thanks for your help. The problem is the Query Wizard only allows you to
select tables or views. It does not let you select SQL stored procedures.
You can cancel out of the wizard and then click the SQL button to enter an
EXEC stored_producer command. When you accept the SQL it does some error
checking and makes sure you have supplied the same number of parameters as
the stored procedure is expecting.

The problem is I don't know how to use a cell reference for one of the
parameters.

Thanks,
Jim
 
J

JimF

Thanks Jamie,

It's good to know VBA can modify the querytable's SQL although I was tring
to avoid VBA.

Have you used SQL.REQUEST?

See my problems with it in the topic "problems with SQL.REQUEST"

Jim
 
Top