davidascott
asked on
FrontPage 2002 Forms and Downloading into an Excel File
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/ illustrato r/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
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/
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
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.
ASKER
For the simple reason that I am very good with Excel and don't have a clue when it comes to Access!!!....and advice??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much for this, I will test tomorrow morning and let you know what happens. Thanks for your help.
Regards,
David
Regards,
David
You are welcome David, let me know what happens.