Fetch SP Data From SQL Server to Excel in Excel
Posted by Knowledge on 19 October, 2009
1 comment so far
This item was filled under [ SQL Server, Tips and Tricks ]
If you are planning to get data from SQL Server to excel by using Excel External Data feature. Please follow the follwing steps :
1. Set all steps by choosing any table.
2. Go To Refresh button > Connection Properties > Definition Tab
3. Change the Command Type to SQL and put the command “EXEC databasename.ownername.StoredProcedurename”
You are done.
Also if your Stored procedure is using temporary table remember to “SET NOCount ON” in the beginning of the stored procedure.
One Comment on “Fetch SP Data From SQL Server to Excel in Excel”