copy from recordset to client excel application 1

[GHOST24]

I have an application that stroes all its information into a sql database as it goes along.
I want to be able to export the data from the table to the client excel application. IN vb i would export in using the copyfromrecordset but i dont know how to launch the client excel apllication and get the data into it or if its posible.

 

[ca8msm]

Change the Response.ContentType to "application/vnd.ms-excel" and read the results out to the page.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[vbkris]

however the data should be in CSV format...

Known is handfull, Unknown is worldfull