Outputting queries to spreadsheets

[robertlevine]

What I'd like to do is export one MSAccess97 query to one sheet of my Excel97 spreadsheet, and another query to a 2nd page in the spreadsheet.

I've tried the TransferSpreadsheet function, but it only allows the user to specify a range for Imports, not exports.

I also tried the OutputTo function, but it doesn't allow me to specify the output sheet either.

Any clues?