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: