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 |
|
Pasi
Posting Yak Master
166 Posts |
 Posted - 2014-08-04 : 17:59:26
|
| HI,How can I open an excel file from a stored procedure? what I like to do to run my SP and at the end add a command to open an excel sheet I have?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-04 : 18:03:21
|
| Your application will need to open the file after the stored procedure completes. Stored procedures run server-side, so the file will open on the server and not be visible to the user.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Pasi
Posting Yak Master
166 Posts |
Posted - 2014-08-04 : 18:05:21
|
Thanks so you are saying that I can not put command at the end of SP to open my excel file?Pasi/quote:
Originally posted by tkizer
Your application will need to open the file after the stored procedure completes. Stored procedures run server-side, so the file will open on the server and not be visible to the user.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-04 : 18:06:40
|
quote:
Originally posted by Pasi
Thanks so you are saying that I can not put command at the end of SP to open my excel file?Pasi/quote:
Originally posted by tkizer
Your application will need to open the file after the stored procedure completes. Stored procedures run server-side, so the file will open on the server and not be visible to the user.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
I am saying that it needs to be done in your application and not inside the stored procedure. Stored procedures should be used for data access and not to do things that an application is designed to do.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
open excel file from SP