Stored Procedure to run in excel

[Gill1978]

Hi All,

I have a stored procedure that I need to run in excel to create a chart, which will be saved as an object in sql server ... does anyone know how I go about this?

Really have no idea ... please help!

Thanks

Julie

 

[Crowley16]

t-sql is only really used against sql server itself, and not external applications.

your best bet would be to use a vbscript to create and load the object outside of t-sql, and only use t-sql to run this script with xp_cmdshell (although this does have security implications...)

--------------------
Procrastinate Now!

 

[TysonLPrice]

You could try running it directly from Excel. Go to data, Get External data, create new query. Set up your connection and run it.

I've never used that to create a chart though.

 

[SQLDenis]

>>Really have no idea ... please help!

why not ask in the Excel forum?
Anyway you probably have to do it in VBA (ALT + F11) and then write the VB code there

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[Gill1978]

Hi,

What I'm trying to do is create charts in an Access Report.
My thoughts on this was to create embedded excel charts in an Access report ... the excel chart would use a stored procedure that is located in the sql server back end. What I'm stuck on is how to actually link the stored procedure to the excel spreadsheet ...

Thanks

Julie

 

[TysonLPrice]

Try here:

http://forums.techguy.org/business-applications/568565-open-excel-chart-access-2003-a.html