Use these steps to load the contents of a View from SQL Server into a new Excel file, or to update an existing file with the current data.

• Open Excel file and go to Data --> Get Data --> From Database --> From SQL Server Database.

save sql view 1

• Enter Server and Database names
Server = servername
Database = databasename

save sql view 2

• Select ViewDataSummary on the Navigator pane, and then click the Load button below the datasheet view.

save sql view 3

• The contents of the SQL Server view will be loaded onto the worksheet adfter a short wait.

save sql view 4

Back to questions list