use excel range to create drop down list in frontpage 2003

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I wish to create a web form that will use a range from an excel file to
create the options in a drop down list, then store the results of the web
form in that same file, is this possible?
 
While you can use an Excel worksheet as a database
See http://support.microsoft.com/default.aspx?scid=268948
But it is not recommend
- because Excel is a single user application
(use an Access DB instead)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I wish to create a web form that will use a range from an excel file to
| create the options in a drop down list, then store the results of the web
| form in that same file, is this possible?
 
That link sows how to use excel in Frontpage 2000, and FP2003 does not seem
to follow those steps. I am not opposed to using access 2003 for the same
functions but am having a time figuring that out as well.

My desire is to use either a spreadsheet or the database to collect updates
from multiple users on their status of current projects.

Thanks for any help you can share,
Gary
 
To both display data from an Access DB (or Excel file),
and allow Edits/Adds of an Access DB (or Excel file),
requires server side coding

If you are not familiar with how to hand code the server side code, then you can try using
- the DBRW for displaying data
(see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp)
- the DBIW for adding/editing data
(see http://spiderwebwoman.com/resources/diwtipsandtricks.asp)

--




| That link sows how to use excel in Frontpage 2000, and FP2003 does not seem
| to follow those steps. I am not opposed to using access 2003 for the same
| functions but am having a time figuring that out as well.
|
| My desire is to use either a spreadsheet or the database to collect updates
| from multiple users on their status of current projects.
|
| Thanks for any help you can share,
| Gary
|
| "Stefan B Rusynko" wrote:
|
| > While you can use an Excel worksheet as a database
| > See http://support.microsoft.com/default.aspx?scid=268948
| > But it is not recommend
| > - because Excel is a single user application
| > (use an Access DB instead)
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > |I wish to create a web form that will use a range from an excel file to
| > | create the options in a drop down list, then store the results of the web
| > | form in that same file, is this possible?
| >
| >
| >
 
Back
Top