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 :
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:
Post a Comment