| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to connect Excel to stored procedures in SQL database? | Excel Discussion (Misc queries) | |||
| Can't see stored procedures in select data source windows | Excel Discussion (Misc queries) | |||
| Running sql stored procedures from Excel | Excel Discussion (Misc queries) | |||
| connect to access database and run a query in excel VBA | Excel Discussion (Misc queries) | |||
| connect a form to excel database | Excel Discussion (Misc queries) | |||
Hybrid Mode
