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 |
andypgill
Starting Member
34 Posts |
Posted - 2012-12-10 : 09:47:13
|
HiIs it possible to create a menu in excel that will run a number of SQL stored procedures.I have just inherited a database, the user needs to go into SQL run each of the three stored procedures, close SQL open excel and refresh the data.I was hoping to create a menu in excel that will run the three stored procedures.I have looked on various websites and they talk about passing data to excel, I don't want to pass any data just to run the procedures.ThanksAndy |
|
Mike Jackson
Starting Member
37 Posts |
Posted - 2012-12-12 : 08:35:38
|
If you have any VBA programming experience, you can create a VBA program in Excel using OCBC that executes an SQL statement.There are lots of examples on the net.Mike |
|
|
|
|
|