That will attempt to display the data as a excel spreadsheet in browser if the user has Excel
See
http://www.devguru.com/Technologies/asp/quickref/response_contenttype.html
If you applied a unique table ID to the db table in a normal ASP page (w/o above header) they should be able to just right click in
the table and select Export to Excel
Or you could create a link to a Excel Download asp page that uses that Content type
- the key is the Response Content Type Must be the 1st tag in the page and the page should only have a table (w/ your Db results )
in it
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| The page is on an internal network so I cannot show it. Let me ask it
| this way:
|
| My goal is to find a way for someone to save the data that is being
| viewed on my webpage in an Excel file.
|
| I make databases for people to gather feed back from associates on an
| Intranet. Some in MS Access and some on an SQL server. The request I
| always get is to have the ability to download the data into Excel so
| they can play with the numbers.
|
| Since they have no access to the databases directly (security reasons),
| I have to export the data into Excel for them. Is there a way for me to
| offer this option to them?
|
| > Try:
| >
| > Response.ContentType = "text/HTML"
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| > ==============================================
| > Agents Real Estate Listing Networkhttp://
www.NReal.com
| > ==============================================
| >
| >
| >
| >
| > >I have MS Access databases that are viewed via ASP pages made in
| > > Frontpage. I have two issues that have the same problem.
| >
| > > 1: When someone views database results on one of my webpages, and
| > > attempts to copy and paste the data in an Excel sheet, they get little
| > > graphics (it looks like a little robot) insteat of data.
| >
| > > 2: When displaying the data in an excel format instead of web....
| >
| > > I use this code:
| >
| > > <%
| > > Response.Buffer = TRUE
| > > Response.ContentType = "application/vnd.ms-excel"
| > > %>
| >
| > > It displays the little robot graphics. Is there anything I can do to
| > > resolve this issue?
| >
| > > Thanks.- Hide quoted text -- Show quoted text -
|
