Data Downloads

T

The Shat Hat Man

I have an online database collecting data from a webform where I display the
results in a Data Results Page. These are pretty limited, so I would like
certain users to be able to download the data into an Excel file. How do I go
about setting that up?
Thank you.
 
S

Stefan B Rusynko

Or if your table has an id attribute they should be able to right click it and select Export to Excel




| Have them highlight the contents of the table, select Copy from the Menu
| bar, open Excel and paste into an empty spreadsheet.
|
| --
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| blog: http://msmvps.com/spiderwebwoman/category/321.aspx
|
|
|
| message | >I have an online database collecting data from a webform where I display
| >the
| > results in a Data Results Page. These are pretty limited, so I would like
| > certain users to be able to download the data into an Excel file. How do I
| > go
| > about setting that up?
| > Thank you.
|
|
 
T

The Shat Hat Man

Unfortunately those are workarounds and exactly what I want to avoid. There
has to be a way to do this via a link. Any ideas?
 
S

Stefan B Rusynko

Then you will need to hand code the page using server side scripting (ASP) and not rely on the DBW to generate the page table
The download to Excel would be initiated by following code at top of page
<% Response.ContentType = "application/vnd.ms-excel" %>





| Unfortunately those are workarounds and exactly what I want to avoid. There
| has to be a way to do this via a link. Any ideas?
|
| "Stefan B Rusynko" wrote:
|
| > Or if your table has an id attribute they should be able to right click it and select Export to Excel
| >
| > --
| >
| > _____________________________________________
| > 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.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Have them highlight the contents of the table, select Copy from the Menu
| > | bar, open Excel and paste into an empty spreadsheet.
| > |
| > | --
| > | ~ Kathleen Anderson
| > | Microsoft MVP - FrontPage
| > | Spider Web Woman Designs
| > | web: http://www.spiderwebwoman.com/resources/
| > | blog: http://msmvps.com/spiderwebwoman/category/321.aspx
| > |
| > |
| > |
| > | message | > | >I have an online database collecting data from a webform where I display
| > | >the
| > | > results in a Data Results Page. These are pretty limited, so I would like
| > | > certain users to be able to download the data into an Excel file. How do I
| > | > go
| > | > about setting that up?
| > | > Thank you.
| > |
| > |
| >
| >
| >
 
T

The Shat Hat Man

That is kinda what I was thinking too but was hopeful of FrontPage having a
built in feature for this. Thanks for the help.

"If you're not wearing a Shat, you're not wearing a hat" - William Shatner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top