I am trying to fill one spreadsheet with 2 SQL queries on my web page.
Usually, I used copyFromRecordset to fill the spreadsheet. But with 2 separate SQL queries, it seems to be not working right - it only fills the sheet with the last query.
I wonder what's the right way to do this?
I know I probably can fill the spreadsheet one cell at a time, which can be slow, from the two separate recordsets. Or I wonder if I can do CopyFromRecordSet for the 1st query, then find out the last row of the worksheet, then fill cell by cell after that. Or if I can do something else easily.
Usually, I used copyFromRecordset to fill the spreadsheet. But with 2 separate SQL queries, it seems to be not working right - it only fills the sheet with the last query.
I wonder what's the right way to do this?
I know I probably can fill the spreadsheet one cell at a time, which can be slow, from the two separate recordsets. Or I wonder if I can do CopyFromRecordSet for the 1st query, then find out the last row of the worksheet, then fill cell by cell after that. Or if I can do something else easily.
