Load ASP in Excel with Multiple Worksheets

[Shawn]

I have the basics working as is described in KB199841.
I currently have my ASP page loading into Excel by
setting the ContentType of the page:
<%response.Cont entType="applic ation/vnd.ms-excel"%>

I can add the following to create multiple worksheets
within the Excel file:
....
<x:ExcelWorkshe ets>
<x:ExcelWorkshe et>
<x:Name>Workshe et1</x:Name>
<x:WorksheetOpt ions>
<x:Print>
<x:ValidPrinter Info/>
</x:Print>
</x:WorksheetOpti ons>
</x:ExcelWorkshee t>
<x:ExcelWorkshe et>
<x:Name>Workshe et2</x:Name>
<x:WorksheetOpt ions>
<x:Print>
<x:ValidPrinter Info/>
</x:Print>
</x:WorksheetOpti ons>
</x:ExcelWorkshee t>
</x:ExcelWorkshee ts>
....

My recordset displays the results on "Worksheet1 " by
dropping the recordset results into a table within the
body of the asp page. Is there a way to get the results
to display on "Worksheet2 "??? I am assuming that the
method of creating the multiple worksheets <above> is
incorrect in doing what I want, so any advice would be
beneficial. I also do not have Excel loaded on my server
and hence am forced to specify the contenttype.