In this article i will show you you how to get data from sql server in excel by run stored procedure in Microsoft Excel.
1. Open Microsoft Excel.
2. Go to Data tab.
3. Then Go to Other data source menu in it.
4.
5. Fill your details in pop-up box as shown in below image.
6. Click on Next > choose database and table > Click Next.
click next.
7. Pop-up will open Click on properties > Definition.
Choose command text to SQL, In command text give the name of the SP
8. Pop-up will open click OK > OK.
9. Reseult will be like this.