How to generate a excel report.

[Guest_imported]

I want to transfer data from Access database and generate a excel report. What should I do? Please give me some idea or pass me code. Thanks in advance.

 

[Guest_imported]

I want to transfer data from Access database and generate a excel report using ASP. What should I do? Please give me some idea or pass me code. Thanks in advance.

 

[bcapps]

Create an .asp page
at the top, enter your code as you usually would:

<%@Language=VBScript>

Then tell the system that you are creating a excel spreadsheet:

<%
Response.ContentType = &quot;application/vnd.ms-excel&quot;
%>

The rest can be the HTML and VBscript you would use to create a table for presentation on a web page, only because you noted that you were sending it to an excel spreadsheet, it will open up in excel.

bc