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 [...]