Form data collection

S

Sal Iaccarino

I have created a form in FrontPage 2003. I have published it and sent data
back via e-mail. All is good.

QUESTION:
Can I end this collected data to an EXCEL spreadsheet? If so, give me a clue
as to how.

THANKS!
Sal and Eileen
 
B

Bob

You can save it to a .csv file.

Set up a form to save form results to a file

One of the simplest ways to collect information about your site visitors is
by saving the form results to a text or HTML file. By default, the file is
located in _private, a hidden directory in your Web site. This directory is
set up so no one can browse to it, making it more secure. You can change
this location and file name as needed, however doing this isn't as secure as
using the _private directory. You also can select the format of the text
file and specify whether to include field names in the form results. In
addition, you can specify a second file in which to save results.

1. In Page view, right-click the form, and then click Form Properties.
2. Click Send to. A default file name and a location for the results file
are displayed in the File name box.
3. You can specify a different file to use by typing the new name and
location in the File name box, or by clicking Browse to locate the file.
4. Click Options, and then the File Results tab.
5. In the File format list, click the file format of the form-results file.
6. Under Optional second file, you can specify a second file to contain form
results. You may want to specify one results file for input to a database or
spreadsheet and the other results file for readability.
To specify a second form-results file, type a name and location in the File
name box, or click Browse to locate the file that you want to use.

7. In the File format list, click the file format of the form-results file.
8. Click OK twice to close the Saving Results and Form Properties dialog
boxes.

Hope this helps

bob
|I have created a form in FrontPage 2003. I have published it and sent data
| back via e-mail. All is good.
|
| QUESTION:
| Can I end this collected data to an EXCEL spreadsheet? If so, give me a
clue
| as to how.
|
| THANKS!
| Sal and Eileen
|
|
 

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