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?
| >
| >
| >
