Export to multiple excel sheets

[RichpU]

Hi Everyone,

I am trying to export a group of tables to an excel workbook
and I would like to export table 1 to sheet 1, table 2 to sheet 2 etc.

I am using <%Response.ContentType = "application/vnd.ms-excel"%>
which exports everything to sheet1.

how can I split it so it outputs to different sheets
Thanks in advance

Regards,
RichPu

 

[Melissa]

Did you ever find a solution to this? I would like to do the same thing.

Thanks,
Melissa