How to connect Excel to stored procedures in SQL database?
 

I need to get data from stored procedures in a sql database. I can't
see the sprocs in the list in "Select database source" window.

How can Iconnect to this information? If not with the user GUI, maybe
with vba?

Lets say the server name = Srv1, database name = DBTest1, user =
User1, pws = empty, sprocs = sptemp_report


Thankful to any help you can offer.
Kind regards
TSkogstrom

How to connect Excel to stored procedures in SQL database?
 

Hi

www.excelkb.com has a load of answers
Access
http://www.excelkb.com/article.aspx?...8&cNode=1I7C3V
http://www.excelkb.com/article.aspx?...5&cNode=1I7C3V

for SQL server or MySQl procedure is similar and although no direct examople
is given - withthe info there you shoud be able to piece it together

HTH


"tskogstrom" wrote:

I need to get data from stored procedures in a sql database. I can't
see the sprocs in the list in "Select database source" window.

How can Iconnect to this information? If not with the user GUI, maybe
with vba?

Lets say the server name = Srv1, database name = DBTest1, user =
User1, pws = empty, sprocs = sptemp_report


Thankful to any help you can offer.
Kind regards
TSkogstrom