How to connect Excel to stored procedures in SQL database?

T

tskogstrom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

passing Nulls to SQL Server 2005 2
Updating Stored Procedures 5
LINQ to SQL vs. Stored Procedures (Performance) 6
Stored procedures 4
Triggers and stored procedures in C# 6
Stored Procedures Query 7
Excel VB triggering Stored Procedures/Queries 3
how can i convert stored procedures in sql to stored queries in ac 1

Top