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....
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:#9tBEXUXDHA.2592@TK2MSFTNGP09.phx.gbl...[color=blue]
> Excel? I assume you have it?
>
> --
> Will trade ASP help for SQL Server help
>
>
> "jason" <jason@catamaranco.com> wrote in message
> news:ua933BQXDHA.2620@TK2MSFTNGP09.phx.gbl...[color=green]
> > 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?
> >
> > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> > news:eIySBYPXDHA.1480@tk2msftngp13.phx.gbl...[color=darkred]
> > > Yeah, it's nice. :] Check out this sample.[/color]
> >
http://www.darkfalz.com/1085/[color=darkred]
> > >
> > > Ray at work
> > >
> > > "jason" <jason@catamaranco.com> wrote in message
> > > news:ej%23%23MQPXDHA.656@tk2msftngp13.phx.gbl...
> > > > 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[/color][/color][/color]
follow....I[color=blue]
> am[color=green][color=darkred]
> > > > struggling to work out whether you mean it will actually be[/color][/color]
> 'displayed'[color=green]
> > in[color=darkred]
> > > > excel format with my asp-html page or whether user has to go extra[/color][/color]
> step[color=green][color=darkred]
> > > and
> > > > 'download' into excel formatted page?
> > > >
> > > > Many thanks
> > > > Jason
> > > > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in[/color][/color]
> message[color=green][color=darkred]
> > > > news:#X#jTEPXDHA.3924@tk2msftngp13.phx.gbl...
> > > > > Yes. Simplest way is to just make an ordinary html table with[/color][/color][/color]
your[color=blue][color=green][color=darkred]
> > > > results,
> > > > > but send it back as Excel using:
> > > > >
> > > > > Response.ContentType = "application/vnd.ms-excel"
> > > > >
> > > > > Ray at work
> > > > >
> > > > > "jason" <jason@catamaranco.com> wrote in message
> > > > > news:%23HLvJCPXDHA.2640@TK2MSFTNGP09.phx.gbl...
> > > > > > Is it possible to write out the contents of a database into an
> > > exel-type
> > > > > > spreadsheet within an asp page?
> > > > > >
> > > > > > - Jason
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
ADO data into web excel?
