Written by

Question Yakov Berger · Aug 19, 2020

SQL To EXCEL

Hi,

I have some SQL querys i would like to run using an Outbound SQL Adapter and save the returned rowsets in excel format (each rowset in a seperate excel file).

What is the best way to do this?

Thanks

Discussion (4)0

Add reply

Comments

Eduard Lebedyuk · Aug 19, 2020

Check this example of SQL to Excel.

You might need to adjust the code to use Outbound SQL Adapter but the general gist it the same.

0 0

Yakov Berger Aug 19, 2020 to Eduard Lebedyuk

Thanks!

Will Check

0 0

Yakov Berger Aug 20, 2020 to Eduard Lebedyuk

Hi Eduard,

How do i set credentials and connection string to run against an external MSSQL Server?.

Thanks

0 0

Eduard Lebedyuk Aug 20, 2020 to Yakov Berger

Check the docs for SQL Gateway.

0 0