exporting a frontpage form into excel

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

 

[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.
==============================================

 

[=?iso-8859-1?Q?Crash_Gordon=AE?=]

Can't you make one record per row work? Seems like a simple enough form.


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

 

[Guest]

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

 

[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.
==============================================

 

[Guest]

That sounds do-able. Thank you.

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

 

[=?iso-8859-1?Q?Crash_Gordon=AE?=]

once you have it exported to your desktop you can manipulate it anyway you want. I use Excel for clean up, then sometimes move it into Access...generally for simple stuff Excel is fine.


| That sounds do-able. Thank you.
|
| "Thomas A. Rowe" wrote:
|
| > 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.
| > ==============================================
| > To assist you in getting the best answers for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| >
| > | > > 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
| > >
| > > "Crash Gordon®" wrote:
| > >
| > > > Can't you make one record per row work? Seems like a simple enough form.
| > > >
| > > >
| > | > > > | 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.
| > > >
| >
| >
| >

 

[Guest]

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.

 

[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.
==============================================

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.

 

[Guest]

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?

 

[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.
==============================================

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?

 

[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.
==============================================

Thank you for the information. I think I'll start with what FP has to offer. One more related

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?