How to export query results to an excel file

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
 
K

Kathleen Anderson [MVP - FrontPage]

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
 
S

Stefan B Rusynko

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
| >
| >
|
|
 

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