ADO data into web excel?

[jason]

Is it possible to write out the contents of a database into an exel-type
spreadsheet within an asp page?

- Jason

 

[Ray at]

Yes. Simplest way is to just make an ordinary html table with your results,
but send it back as Excel using:

Response.ContentType = "application/vnd.ms-excel"

Ray at work

 

[Ray at]

Yeah, it's nice. :] Check out this sample. http://www.darkfalz.com/1085/

Ray at work

 

[Ray at]

Excel? I assume you have it?

--
Will trade ASP help for SQL Server help

Hmmm Ray - it seems simple - slap the code above my asp generated db
table...but...nothing happens! It still justs outputs as plain html.....

...am I missing something here?

Yeah, it's nice. :] Check out this sample. http://www.darkfalz.com/1085/

Ray at work

Wow....so I can build an html table via ADO and then convert it into
excel.....awesome....do you have a simple example I could follow....I am
struggling to work out whether you mean it will actually be

'displayed'

in step
and

 

[jason]

Ok - the problem was I need to call the page rather than just refreshing the
browser....when I did this it loaded as excel - thanks....

Excel? I assume you have it?

--
Will trade ASP help for SQL Server help

Hmmm Ray - it seems simple - slap the code above my asp generated db
table...but...nothing happens! It still justs outputs as plain html.....

...am I missing something here?

Yeah, it's nice. :] Check out this sample. http://www.darkfalz.com/1085/

Ray at work

Wow....so I can build an html table via ADO and then convert it into
excel.....awesome....do you have a simple example I could

follow....I

am 'displayed'