?
Solved

FrontPage 2002 Forms and Downloading into an Excel File

Posted on 2005-04-13
5
Medium Priority
?
210 Views
Last Modified: 2013-12-24
I would like to start capturing data on my website (www.dieselhousestudios.com) whereby potential artists could fill in a form capturing data such as

Name
Surname
Address 1
Address 2
Address 3
Town
City
Post Code

Size of space required    (with drop down list showing different sizes eg 100/200/300/400/500 sq feet)
When is space required    (with drop down list showing month of the year)
Would you share    (with drop down list showing yes/no)
Please detail any specialist requiements    (free text up to 5 lines of text)
What is your budget    (with drop down list showing prices £100/£200/£300/£400 per month)
Creative Medium (with drop down list showing painting/scupture/ceramic/illustrator/other - please detail with free text box added)

I would then like the ability for the visitor to press 'submit' and this data would be able to be downloaded into Excel to keep a mini database.

Please would you show (preferably) a very easy to use add-in (where I don't have to use code) and how I would download into Excel. Otherwise you could show me how I would do this within FrontPage itself if it is fairly straightforward.

Thanks and regards,
David
0
Comment
Question by:davidascott
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:hhammash
ID: 13770545
Why Excel?  You can do that very easily with Access.  It will be easy to utilize the database.  You can simply do that with Access.  With Excel you will have some difficulties.
0
 

Author Comment

by:davidascott
ID: 13776990
For the simple reason that I am very good with Excel and don't have a clue when it comes to Access!!!....and advice??
0
 
LVL 14

Accepted Solution

by:
hhammash earned 2000 total points
ID: 13777167
I asked because you might face difficulties with Excel.

- Create the Excel sheet with the required columns
- Import it to your web
- Create a connection for it using Tools > Web Settings > Databases > Add
- File or folder in the current web
- Select file type xls
- Select the excel file
- OK,  OK
- You will see the database connection name with a big blue question mark
- Click once on the connection and then click Verify button
- Now you will have a green tick mark
- Click Modify > Advanced
- In the other parameters click Add
- In name box, type exactly this:  ReadOnly
- In the value, type a zero:  0
- OK (by doing this you made the excel file writeable)  if you don't do this,  you will not be able to write to the file

Now
Create a form, give each pull down menu the same name of it's corresponding excel sheet column
Post the form to the database connection that you created

Save the page with .asp extension.

Now when you fill the form and submit it you will write to the excel sheet.

hhammash


0
 

Author Comment

by:davidascott
ID: 13778253
Thanks very much for this, I will test tomorrow morning and let you know what happens.  Thanks for your help.

Regards,
David
0
 
LVL 14

Expert Comment

by:hhammash
ID: 13781040
You are welcome David,  let me know what happens.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question