Hi,
I have got a requirement where i need to output three separate SQL query result sets into three spreadsheets of an excel file.
Is there any way of doing this? Please advise.
Thanks in advance!!
Sue
Loading into Multiple Spreadsheets in Excel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Wed Jul 06, 2005 12:29 am
I'm guessing here that multiple "spreadsheets" actually means multiple "worksheets" all in a single spreadsheet. While you can read something like that, I don't believe you can write natively to one... other than as separate .csv or .prn files as noted.
Could be wrong.
Could be wrong.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Using an ODBC driver for Excel, the DSN refers to the workbook and each worksheet in the workbook - subject to certain requirements - presents as a system table from that data source.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not really. What I wrote is clear.
If you're asking about the "certain requirements" these are documented in the ODBC API manual (from Microsoft) - in essence the worksheet must be in strict columnar form and have ODBC-legal column headings.
If you're asking about the "certain requirements" these are documented in the ODBC API manual (from Microsoft) - in essence the worksheet must be in strict columnar form and have ODBC-legal column headings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.