Export SQL query results into a multi tabbed Excel spreadsheet

Vote count:

0

I want to write a set of 100 select queries in DB2 10.1 to return all rows in each table in the database and have the results exported to an excel spreadsheet with a new tab for each result set.

Is this possible and if so how can I do it?

At the moment the only way I can do this looks like to export each result set and then manually create the multi tabbed spreadsheet by copying each tab across.

Thanks

asked 52 secs ago

user3165854

1

Export SQL query results into a multi tabbed Excel spreadsheet