Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fuzzyjon
Starting Member
15 Posts |
 Posted - 2008-06-08 : 16:37:01
|
| HelloIs it possible to run some SQL Stored Procedures (on our server) via Excel on my workstation and pull the results back into Excel?I have several Stored Procedures which are sitting on the server, and I need my colleagues to be able to access and run them easily, and this is the only way that I can think of doing that!Thanks,Jon |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-08 : 16:56:25
|
| Possible if you can get some vb script in excel. |
 |
|
|
Johnho008
Starting Member
24 Posts |
Posted - 2008-06-09 : 04:54:24
|
| you could always write a bat file using sqlcmd command;sqlcmd -S{servername} -i {store procedure script location} |
|
|
|
|
|
|
Using SQL Stored Procedures in Excel