How to export query results to an excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a website where customers are able to view their tickets along with
the details of the ticket. I am using Database Results Wizard in Frontpage,
and it shows the results in the table.

Is there any way to export the results to an Excel file?

Any help will be greatly appreciated!

Thanks,

Shikha
 
In addition to Thomas' excellent answer, a quick-n-dirty way to do this is
have your customers highlight the entries in the table, choose copy and then
paste into an empty Excel spreadsheet.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
Or if they have Excel installed and the table has a unique table Id the should be able to right click in the table and select Export
to Excel

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| In addition to Thomas' excellent answer, a quick-n-dirty way to do this is
| have your customers highlight the entries in the table, choose copy and then
| paste into an empty Excel spreadsheet.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| Please reply to the newsgroup for the benefit of others
|
|
| | > You would have to write a custom ASP/VBScript that would allow each
| > customer to generate a Excel file.
| >
| > See:
| > http://aspalliance.com/1_Dynamic_Excel_Reports_with_ASP
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| >
| > http://www.Ecom-Data.com
| > ==============================================
| >
| >
| > | >> Hi,
| >>
| >> I have a website where customers are able to view their tickets along
| >> with
| >> the details of the ticket. I am using Database Results Wizard in
| >> Frontpage,
| >> and it shows the results in the table.
| >>
| >> Is there any way to export the results to an Excel file?
| >>
| >> Any help will be greatly appreciated!
| >>
| >> Thanks,
| >>
| >> Shikha
| >
| >
|
|
 
Back
Top