Front Page Forms should be in an Excell format when e-mailed

[Sandra Stewart]

Answers that are generated in Front Page forms should be in an excel format.
This would make it possible to do statistical analysis or to import it in to
statistical programs. Research folks who build questionnaires would not then
have to re enter data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...fc45684b&dg=microsoft.public.frontpage.client

 

[Thomas A. Rowe]

You can set the form results to be send or stored in CSV format which will then open in Excel.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Thomas A. Rowe]

Or you can learn to use ASP, etc and store the data in a database, then you would be able to do your
analysis on the data directly online.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Andrew Murray]

plus you can also import an Access DB table into Excel, and vice versa -
import Excel xls file into Access as the datasource.

 

[Sandra Stewart]

How do you do this?
As Typical I can not find anything in the Manuals I have. Checking the form
properties shows no obvious way of doing this.

 

[Thomas A. Rowe]

Did you look under Form Properties, options. store or email results?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================