Output Data to Excel via Hyperlink

[Tony]

I'm working in FrontPage 2002. I have created an ASP page
that returns database results based on two passed
parameters. Lets call them "Product" and "Sub-Product".
The data that meets the criteria passed is returned as an
HTML table. I want to put a hyperlink at the top of the
page that will take the same results and present them as
Excel in the browser. My users not only want to "see" the
data (HTML) but will want to download it as Excel for
manipulation. I've searched the FrontPage help and all MS
support sites until I was blue in the face and cannot
figure out how to do this. Any help is greatly
appreciated.

 

[Stefan B Rusynko]

Not a programming approach, but are you aware that in IE6 if your client right clicks a table and selects Export to Microsoft Excel,
it will open an Excel Worksheet and create a table of the html data in Excel which the user can save
- make sure all your tables have unique IDs

You can also do it programmatically With a web query from Excel 2002
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xmlss.asp



| I'm working in FrontPage 2002. I have created an ASP page
| that returns database results based on two passed
| parameters. Lets call them "Product" and "Sub-Product".
| The data that meets the criteria passed is returned as an
| HTML table. I want to put a hyperlink at the top of the
| page that will take the same results and present them as
| Excel in the browser. My users not only want to "see" the
| data (HTML) but will want to download it as Excel for
| manipulation. I've searched the FrontPage help and all MS
| support sites until I was blue in the face and cannot
| figure out how to do this. Any help is greatly
| appreciated.

 

[Guest]

Actually, I would be very happy with your first approach,
however, I use IE6 and when I right click on the table,
there is NO option to save/export to Excel. Is there an
option in IE that needs to be set for this menu choice to
appear? What do you mean by "unique IDs" regarding tables?

-----Original Message-----
Not a programming approach, but are you aware that in IE6

if your client right clicks a table and selects Export to
Microsoft Excel,

it will open an Excel Worksheet and create a table of the

html data in Excel which the user can save

 

[Stefan B Rusynko]

User Require IE 6 and Excel 2002
See http://support.microsoft.com/defaul...port/kb/articles/Q277/6/21.asp&NoWebContent=1




| Actually, I would be very happy with your first approach,
| however, I use IE6 and when I right click on the table,
| there is NO option to save/export to Excel. Is there an
| option in IE that needs to be set for this menu choice to
| appear? What do you mean by "unique IDs" regarding tables?
|
|
| >-----Original Message-----
| >Not a programming approach, but are you aware that in IE6
| if your client right clicks a table and selects Export to
| Microsoft Excel,
| >it will open an Excel Worksheet and create a table of the
| html data in Excel which the user can save
| >- make sure all your tables have unique IDs
| >
| >You can also do it programmatically With a web query from
| Excel 2002
| >See http://msdn.microsoft.com/library/default.asp?
| url=/library/en-us/dnexcl2k2/html/odc_xmlss.asp
| >--
| >
| >_____________________________________________
| >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
| >_____________________________________________
| >
| >
| [email protected]...
| >| I'm working in FrontPage 2002. I have created an ASP
| page
| >| that returns database results based on two passed
| >| parameters. Lets call them "Product" and "Sub-Product".
| >| The data that meets the criteria passed is returned as
| an
| >| HTML table. I want to put a hyperlink at the top of the
| >| page that will take the same results and present them as
| >| Excel in the browser. My users not only want to "see"
| the
| >| data (HTML) but will want to download it as Excel for
| >| manipulation. I've searched the FrontPage help and all
| MS
| >| support sites until I was blue in the face and cannot
| >| figure out how to do this. Any help is greatly
| >| appreciated.
| >
| >
| >.
| >