I would like to create a SQL procedure to be used in Excel. I am looking for a way in Excel to create a single tab for this. The top of the tab would have the parameters to pass to the SQL procedure, then there would be some type of button to execute. The results then show in the same tab.
Does anyone know if this is possible? I currently have some SQL views being populated in Excel tabs, I am hoping there is a similar feature for SQL procedures.