How to get Data from SQL View in Excel Sheet

Get Data from SQL View in Excel Sheet:

(1) In this blog, we will establish a connection between excel and SQL View (View is a virtual table and it behaves like an original table).

(2) Open the Excel sheet and select the “DATA” tab (System must have MS Excel) as shown.

open microsoft excel
in ms excel select the data tab

(3) After that select the option “From other Sources” and then select “From SQL Server” as shown.

in excel selct option from other sources and then select from sql server

(4) After selecting the above option, a new pop-up window opens. In the Server name field enter the SQL server name. In the log on credentials field, there are two options “Use Windows Authentication” and “Database Login”( Depending on the SQL Server Installation).

connect to database server

(5) After doing the above step, select Database from the drop-down list and then Select View> Press the “Next” button as shown.

data connection wizard in sql

(6) After doing the above step, a new window opens and press the “Finish” button as shown.

save data connection file and finish through wizard

(7) New window open, press ok, as shown.

import data tab

(8) After that, the connection has been created between SQL View and Excel and data displayed on the excel sheet.

SQL View data on excel

How to Create Connection between Excel and SQL database
Development of Table through Wizard in AL D365 BC
How To Import License File In Business Central D365 On-premises
Build an Assisted Setup in Dynamics 365 Business Central– Microsoft Docs

Leave a Reply