Posts Tagged ‘SQL Server’

Running a SQL Stored Procedure from Excel (No VBA)

May 4th, 2010

We all know we can use MS Query to get data from a SQL server. Typically though, we pull from a Table or a View. Well in some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. This adds a level of risk management and makes the DBAs feel better.

 

So today, I’ll show you how to easily make Excel run a Stored Procedure to get data.

  » More: Running a SQL Stored Procedure from Excel (No VBA)