Importing sql query output in excel

Question

I have few queries writtern in different rows in excel like
In Sheet1
cell A1 - SELECT * FROM DBO.EMP
cell A2 - select * from dbo.dept
cell A3 -
select * from dbo.emp
except
select * from sa.emp
cell A4 - select * from sa.loc

now I want these queries to be fired in some test db in sql server 2017,

and the output for query should be writtern in new sheet (sheet2) like
in cell A1 - query should be there
and from cell B1 , output should get printed
The next query should get printed after the first query output. Like if the first query results ends in row - B12,
the second query output should start from row B13, and the second query in the new sheet should be displayed in cell A13
Similarly for other queries writtern in sheet1

I Dont want to use any VBA code for this.

Office version - Microsoft office Profession Plus 2016
Database Tool Version- SQL Server 2017

Answer 1

I Dont want to use any VBA code for this.

There is no build-in feature in MS Excel to achieve this; VBA (or a .NET app) is the only way I know.

Answer 2

You can look into Powershell or Python for solutions as well.

Answer 3

Hi, @AbdulWahab Khan
Entering sql statements in cells to query this may not be possible. The recommended approach is to enter a statement in the dialog box to query after connecting to the database.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.