There is a SQL database that I have read access (can run a query) but can't modify stored procedures, etc. I have complex stored procedure that I run against that database, then I cut/paste the results into Excel. The stored procedure requires modification from time to time otherwise I'd have the DBA add it as a procedure in that database.
Is there a way I can embed the stored procedure into Excel and have it automatically update the spreadsheet? I've played around with Excel, made the connection to the server but can't seem to figure out how to make the stored procedure part of the Excel sheet.
Thanks