Categories
Sql Server

How To run a Stored Procedure Through Microsoft Excel

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.
Excel strored procedure
 

 

 

5.  Fill your details in pop-up box as shown in below image.

excel_sp2

 

 

 

 

 

 

6. Click on Next > choose database and table > Click Next.

excel_sp2

 

 

 

 

 

 

click next.

 

 

 

 

 

 

 

7.  Pop-up will open Click on properties > Definition.

Click on Next.

 

 

 

 

 

 

 

 

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.