Hey there,
Basically what I want to do is..
1. take user input and retrieve a recordset from one of my databases.
2. then create an excel file and write the data into it.
3. save that file on the server and be done.

I know how to get the data in step 1. but beyond that I haven't been able to
find a way to create the excel file.  I've read some posts on being able to
use a DSN to connect to an existing excel file then read and update it, but
haven't seen anything about actually creating the file.

If you have any solutions please throw them my way..
thanks
-casey

That's one way to do it, but it makes the server do a lot of work. 15
seconds has a great article on the subject, located at
http://www.15seconds.com/Issue/970515.htm . I copied their code and it
worked great!