SQL To EXCEL

Question

Question

Yakov Berger · Aug 19, 2020

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

Log in or sign up to continue

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

score 0 · Answer 1 · 2020-08-19T09:30:47-04:00

Yakov Berger · Aug 19, 2020

Thanks!

Will Check

0 0

score 0 · Answer 2 · 2020-08-20T07:26:45-04:00

Hi Eduard,

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

Thanks

score 0 · Answer 3 · 2020-08-20T07:39:31-04:00

Eduard Lebedyuk · Aug 20, 2020

Check the docs for SQL Gateway.

0 0