i have a form on a website in front page and want data to go into.

[taylor]

I have a website with a form on it. Site was done in Front Page 2002.
I gave been collecting data from this form for nearly a year now (such
things as name, address, email etc). Just got whole 2003 office suite
installed and i want to know how I can transger the data from the server into
an excel spreadsheet. I realize i have to access the server's
_private/formrslt.htm file (which I did) and I saw ALL my data. But HOW do i
get it into an excel document neatly and according to the field names?

The form is configured to send to email as well as save to private folder.
The file format is HTML definition list (which may be a problem but I dont
know)....The email format is formatted text and includes teh field names.

I wouldnt think i would have to manually enter all the data into the
spreadsheet...I've tried various alterations of both the form properties
(like switching to csv etc) and Ive also fooled around importing from teh
excel end to no avail...

can anyone help???

 

[Mark Fitzpatrick]

Unfortunately, there's no easy way. HTML definition lists aren't really good
for importing into Excel. Excel needs csv, which means that instead of HTML,
all fields are seperated by a comma (hence the comma seperated values) and
have only one entry per line. You may be able to work out a find and replace
to change some of the html tags and just replace them with a comma using a
text replace (notepad can even do that) but it's going to be tricky to
ensure that the last line is done properly. With luck you can use a find and
replace on all but the very last field. YOu might copy one record into a new
text file to experiment with breaking it into comma or tab seperated values,
then import into Excel to see how it looks. Sorry I can't give a better
solution but this is just one of those gotcha's that occurs every now and
again after something has been done.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Bob Richardson]

Would it work to first read the HTML data into Word, and then save that into
a TXT or another format?

 

[taylormorgan2004]

cawell see actually that the thing....

IN front page, i can confgure the type of file i want that data saved in and
the format. for example:

when insode the form in NORAM view i can right click and select form
proporties.

in form propertiest here are several options:

I can:
save to file by browsing to a file
or to _private/formrslt.htm which is housed on server

or to an email address

or a database which it will automatically configure for you as fpdb(which i
assuem is frontpagedatabase)pagename.mdb(which is microsoftdtabase)

OR (yes theres more!) you can save to a custom database like a iaspi or cgi
script

now,

i ususally select to send to email which automatically saves the data also
in the _private/formresult.htm file BUT they give me OPTIONS


I can select a file FORMAT such as HTML (and various options in that catagory
Formatted Text and several option there, and text separated by commas,
spaces or tabs....

I thought maybe i could format it to spit out text separated by commas adn
then be able to pull it into Excel.

I also tried reconfoguring it to save as the mdb file i mentioned becasue i
think excel accepts that format as well...but no success...

I am wondering if theres a way to extract the data and place it in a CSV
file or save it as a CSV file? or if theres a way to convert an mdb file in
to a csv or some thing???

I cannot imagine that these programs wouldnt work together somehow with the
proper configureations...afterall it IS microsoft!