DSXchange

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

Write three queries in 3 database stages and output them to sequential file with file name as <youropfilename>.xls and in properties tab specify the delimter as tab from the listed drop down in the window.DO the same for other 2 files too.

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.

Chulett,

You are correct. I meant to say "worksheets' not "Spreadsheets".

Three result sets in the same spreadsheet.

Is there any way to do this? It is fine even if it is a CSV file.

Thanks

Sue

Not that I know of, using csv files will get you separate spreadsheets, not worksheets. Perhaps using an ODBC driver for Excel???

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.

Ray,

Thank-you for the reply. Could you please provide me more information on what you said in your previous reply?

Thanks

Suresh

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.