View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Souris Souris is offline
external usenet poster
 
Posts: 107
Default MS Query to read data from SQL server stored procedure

I have a spreadsheet which reads data from SQL server stored procedure result
set. It works if I do not need pass parameter to the stored procedure through
ODBC.
I would like to pass paramter to the stored procedure.

For exmaple:

MyProc @Param1 = '1111'

I wanted to pass Param1 to MyProc from sheet1.A1.

Is it possible to do the work?

Any information is greate appreciated