how to export data to excel

[H2]

Hi,
please tell me how to export data from database to excel file by ASP?

thanks
H2

 

[bobmm]

There are nuerous ways to do this...the two most common are:
Get the data from SQL into Excel via ADO
or
Get the data into recordset structures and pass that data into an Excel template file

 

[H2]

Can you tell me more details for the second method (Get the data into recordset structures and pass that data into an Excel template file)?
thanks

 

[bobmm]

Use standard ADO techniques for getting the data to your ASP layer then invoke an instance of Excel(must be installed on the server) opening the template and inserting the data into a pre-defined cell range….you can hang charts and graphs off this data range…or do anything you want with it via macro’s etc….

cheers

 

[phildownunder]

hi
if excel isn't available on the server (can be the case with IIS servers)
then you can setup a csv.dsn (Microsoft Text Driver)
you can then use ADO to operate on comma delimetered files. these can be
be moved to the client and opened in excel
phil

 

[apatelnz]

i have also done this - created a xls (excel 97) from sql server 7.0 via ASP. however i am having huge performance problems..

any suggestions?
thanks in advance

 

[TechnicalAnalysis]

Check this

http://www.4guysfromrolla.com/webtech/022801-1.shtml

 

[slechols]

Is there a way to do this and have each column formatted? I have tried it with VBA, and excel opens, but there is no data.

 

[ISPrincess]

Is there a way to have the client's version of Excel programatically open in order to display the newly created spreadsheet without programatically saving it?

 

[rasx]

Please see the following links:



INFO: Considerations for Server-Side Automation of Office (Q257757)

http://support.microsoft.com/support/kb/articles/q257/7/57.asp

HOWTO: Display ASP Results Using Excel in IE with MIME Types (Q199841)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q199841

Bryan Wilhite
rasx@kintespace.com

http://www.kintespace.com/kb

 

[ISPrincess]

Thank you - this link is the one that really nails what I need to do.

http://www.devx.com/premier/mgznarch/vbpj/2001/05may01/wd0501/wd0501.asp