How to have sql result in excel then email with asp 1.1?

I can find solution for 2.0 but not 1.1, but my office I am working at only use asp 1.1, so please help! I need to write asp that get a sql query result, transform it as an excel file then attach it in an email then send it. Hope someone knows how to do that with 1.1!
 


 
 
...