Viewing 11 posts - 16 through 26 (of 26 total)
Alvin Ramard (6/12/2015)
Take a look at the link below. It should provide most of the information you need to do this from Excel.http://realworldsql.com/2012/06/07/stored-procedures-with-parameters-in-excel/
Thanks for the link!
However, when I follow...
June 12, 2015 at 2:16 pm
Luis Cazares (6/12/2015)
The Stairway to Reporting Services will guide...
June 12, 2015 at 1:49 pm
Sean Lange (6/12/2015)
Are you familiar with VBA?
Just enough to be dangerous, because I don't use it, everyday. 🙂
June 12, 2015 at 1:19 pm
Sean Lange (6/12/2015)
Why do you think you can't access a stored procedure from Excel?
Because when I connect to my SQL database through excel, I only see tables and views.
June 12, 2015 at 1:10 pm
Lynn Pettis (6/12/2015)
Are the dates user selectable or are they determined by when the query is run?
user selectable
June 12, 2015 at 12:56 pm
I appreciate the helpful replies.
Stored procedures aren't much help, because I can't directly access them through Excel (only tables and views).
So, I would still have to take the results of...
June 12, 2015 at 12:54 pm
Sean Lange (6/12/2015)
June 12, 2015 at 12:51 pm
I think I'm just going to have to resign myself to the fact that I'm going to have to "manually" change the dates, every time, then copy/paste/format the data into...
June 12, 2015 at 12:38 pm
Sean Lange (6/12/2015)
tsobiech (6/12/2015)
Put some parameters in your Excel document. You could even build logic into the VBA if you want.
I tried copying the SQL from server manager to Excel,...
June 12, 2015 at 12:33 pm
I need to run this report quarterly, thus it would be so much easier if I could just use something like Excel to "query" this data and return only a...
June 12, 2015 at 12:03 pm
I'm confused, the function executes, but it doesn't prompt me for dates.
It just uses the dates provided in the "call" portion.
Things would be so much easier if I could just...
June 12, 2015 at 11:44 am
Viewing 11 posts - 16 through 26 (of 26 total)