Generate multiple Excel worksheets from ASP

[girija]

I have to generate a Excel report from ASP which should write recordset data in 3 worksheets in the same workbook.

I was using this method
<% Response.ContentType = "application/vnd.ms-excel"%>
and i realized that this could be used to write in single sheet only.

I tried using the CreateTextFile
Set act = fso.CreateTextFile(server.mappath("girija.xls"), true)
but i have no Create Permission on Web server.

Can anyone suggest any other method to achieve this.
Either i should write to 3 sheets in a workbook or the worst case i should write to 3 different spreadsheets with a click on button.

any help would be appreciated. thx.