Forms Database Help

J

Jay Gustafson

Hello,

If I make a form/survey on my website, how do I go about storing that data onto the server, so I can then download that data whenever I want and export it into MS Excel?

I was looking into this website: formsite.com but I would really like avoid using a service to do this. Can someone please tell me what my options are? Pass some useful links? I am completely lost when it comes to this.

Thank you,
Jay
 
T

Thomas A. Rowe

You have to first determine what server-side script and database your host supports, then you can
post back for help.

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

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


Hello,

If I make a form/survey on my website, how do I go about storing that data onto the server, so I can
then download that data whenever I want and export it into MS Excel?

I was looking into this website: formsite.com but I would really like avoid using a service to do
this. Can someone please tell me what my options are? Pass some useful links? I am completely
lost when it comes to this.

Thank you,
Jay
 
M

MD Websunlimited

Hi Jay,

Assuming that you're hosting on a Windows Platform you can use the Database Interface Wizard to create the form and store the information to an Access database.

See http://office.microsoft.com/assista...CTT=1&Origin=EC010231151033&QueryID=vFr5fojNz

For additional information.


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

Hello,

If I make a form/survey on my website, how do I go about storing that data onto the server, so I can then download that data whenever I want and export it into MS Excel?

I was looking into this website: formsite.com but I would really like avoid using a service to do this. Can someone please tell me what my options are? Pass some useful links? I am completely lost when it comes to this.

Thank you,
Jay
 
A

Andrew Murray

Use the database connection wizard in Frontpage - it makes an MS Access
database - so you can then make a page with ASP (part of the results wizard in
FP) to display the data. You can also download the file and open it in MS
Access.

Are you using frontpage?

Hello,

If I make a form/survey on my website, how do I go about storing that data onto
the server, so I can then download that data whenever I want and export it into
MS Excel?

I was looking into this website: formsite.com but I would really like avoid
using a service to do this. Can someone please tell me what my options are?
Pass some useful links? I am completely lost when it comes to this.

Thank you,
Jay
 
S

Stefan B Rusynko

Save your results file as tab delimited CSV (to a .txt or .csv file) in the _private folder
- say: result.csv
Open your online site and export the result.csv to you desktop or a folder, then double click if for Excel to open it




Hello,

If I make a form/survey on my website, how do I go about storing that data onto the server, so I can then download that data
whenever I want and export it into MS Excel?

I was looking into this website: formsite.com but I would really like avoid using a service to do this. Can someone please tell me
what my options are? Pass some useful links? I am completely lost when it comes to this.

Thank you,
Jay
 
Top