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