Microsoft Excel How To: Query a Microsoft SQL Server Database in Excel with a SQL Query

Peter Musu`
1 min readAug 5, 2020

--

Microsoft Excel How To: Query a Microsoft SQL Server Database in Excel with a SQL Query

1) Click on the Data tab

2) Click on From Other Sources

3) Click on From SQL Server

4) Enter Server Name and Log on Credentials.

5) Select the Database and Table (Even if you are using a query, select a table just the same).

6) Enter ‘FileName’.

7) Enter ‘Description’

8) Select Only Create Connection.

9) In Data Tab click on Existing Connections.

10) Select Connection.

11) Click on Connection Properties.

12) Click on Definition.

13) Click on command type: SQL

14) Enter the SQL query.

15) Click on Table if you want to insert the table in the Excel Sheet.

16) The data will be displayed in the Spreadsheet.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

No responses yet

Write a response