SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 open excel file from SP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Pasi
Posting Yak Master

152 Posts

Posted - 08/04/2014 :  17:59:26  Show Profile  Reply with Quote
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

USA
37142 Posts

Posted - 08/04/2014 :  18:03:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Pasi
Posting Yak Master

152 Posts

Posted - 08/04/2014 :  18:05:21  Show Profile  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 08/04/2014 :  18:06:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000