Excel - How to pull data from SQL Server

This article is about pulling data from SQL Server into Excel sheet .

Open Excel - > Under Data tab - > From Other Sources - > click the drop-down - >  click on From SQL Server .








   Give the Server name and login credentials :





Select the Database  and Table/View from which you want to pull data .


 


Give the file name and click on Finish .




Again you will be prompted for Table / View from which you want to pull data .




Select the type in which you want to view the retrieved data and then click on Properties ...



Under Usage pane - > select the refresh options to update the data in the excel sheet whenever data gets updated in the database .



Under Definition pane - >  If you want to pull data from T-SQL query or by executing
Stored procedure - > select the Command type as SQL and place the query in the Command text .



If you click OK , you can notice data getting populated as shown below :



 
 
 

No comments: