Unanswered

Include Header data from SQL Server Connection to Excel

(0) Share

Report

Posted on by admiral70

I have built an automation that connects to a SQL database, runs a query, launches Excel, writes query results to Excel, closes and saves to a file. This all works except I am not pulling in the header data from the query. Any ideas?

As seen in the image the query has column names. Those column names are not transferring to the excel spreadsheet when it is created.

Any help is greatly appreciated.

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @admiral70 ,

Can you maybe share some screenshots to help describe the issue you are experiencing?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
admiral70 4 on at

Like
a
(0)

Report
Copy link

Link copied!

As seen in the image the query has column names. Those column names are not transferring to the excel spreadsheet when it is created. Appreciate any ideas or solutions.
eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @admiral70 ,

Running a query in SSMS is a little different.

In your flow, it will only return the results. Otherwise your ROWCOUNT will always be 1 even if no results are found.

You can try modifying your query to include a UNION and hardcoding your columns or querying the system tables e.g.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YourTableName'

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn