exporting a frontpage form into excel

M

Melissa

I am trying to create a census form. HR will go in and fill out the
form listing employee names and other information and then submit it.

My problem is I need it delivered so that excel can open the file

I have created the form in FP 2003 and switched the form properties to
"text database using..." and that works in the sense that I can open
the results in excel

but it opens onto one single line in Excel. Is there a way to format
this form so that excel separates the different items

This is an example of what the form looks like and how I would like
the information to be output.

http://home.comcast.net/~melissa.mckean/census-form.gif

Is this just not possible, or am I missing a very easy solution
any help would be appreciated.
 
T

Thomas A. Rowe

No possible. Each form is store as a single record, 1 row.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
A

Adela D

I have a similar need.
How would we get it in the format of one record per row?
I assume if we can do that, then we can use excel to seperate by commas or whatever.

Adela
 
T

Thomas A. Rowe

FP will automatically write it to the .csv file as 1 row per form completed, separated by commas.
This is set under Form Properties. You would have to open the live site in FP and then export the
file to your desktop from the _private folder

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
A

Adela D

That sounds do-able. Thank you.

Thomas A. Rowe said:
FP will automatically write it to the .csv file as 1 row per form completed, separated by commas.
This is set under Form Properties. You would have to open the live site in FP and then export the
file to your desktop from the _private folder

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
Click to expand...
 
A

Adela D

O.K. That will work for me.

Unfortunately, I was hoping for something automatic. I manage a site for an organization that has a early conference. We accept program proposals, and the person in charge of that has to type everything into an Access database. I was trying to find a way to make his job easier.
 
T

Thomas A. Rowe

If the site is hosted on a Windows IIS server, then you could use ASP and Access to store data
directly into the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Adela D said:
O.K. That will work for me.

Unfortunately, I was hoping for something automatic. I manage a site for an organization that has
Click to expand...
a early conference. We accept program proposals, and the person in charge of that has to type
everything into an Access database. I was trying to find a way to make his job easier.
 
A

Adela D

O.K. That site is hosted on a commercial server (Interland), so I will start reading up. I can do this with FP... don't have to buy any add-on?
 
T

Thomas A. Rowe

Yes, if it is very basic you can use FP's database components, otherwise you will need to learn
ASP/VBScript which is a good idea anyway.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Adela D said:
O.K. That site is hosted on a commercial server (Interland), so I will start reading up. I can
Click to expand...
do this with FP... don't have to buy any add-on?
 
T

Thomas A. Rowe

Depending on the requirements, you could also do this via the FP database components. I found the
following site helpful when I start working with ASP/VBScript:

http://www.asp101.com

I think you really should consider learning ASP/VBScript because most examples that you find on the
web are not related to the way FP has to generate ASP code.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Adela D said:
Thank you for the information. I think I'll start with what FP has to offer. One more related
Click to expand...
thing. Right now, we post our program on regular HTML pages. We would love to be able to have a
attendee search the program by all of our codes for areas of interest. Can you point me in the
general direction of how this might be done?
 
Top