"mkarja" wrote in message
m...
Hi,

I have a stored procedure in SQL Server 2000 that returns result
as text. I want to run that stored procedure from excel, but I'm
a bit lost on how to do that. I can get a normal result set from
sql server to excel.
The results should go into a text box.

Any help is much appreciated.

----
mkarja


I guess you could use something like this:

call procedure_name[([parameter][,[parameter]]...)]}
where procedure_name specifies the name of a procedure and parameter
specifies a procedure parameter.



Does your stored procedure take any arguments?

/Fredrik