Exporting recordset data to an Excell sheet from an ASP page

[mohaimen]

Hi,

I want to export the data of a recordset to an Excel sheet in the client computer from an ASP page.

Please tell me how to do it.

Regards.

Mohaimen

 

[bigozz]

Instead of an Excel file, create a CSV file on the server using the a server side instance of the FileSystemObject. When you have finished creating the file, just add a link to the file. The CSV file will open in Excel. If you are using a later version of IE, it will actually open a worksheet in the browser.

Hope this helps