What I need to do here should be simple, but I am being pulled in many directions. I need to create a web page that will link to fields in a database, spreadsheet or any document from which data can be retreived. I have a database of names, addresses, images, etc. that I would like to have read from a web page. As an example, if the webpage uses a table, and the first cell in that table is looking for “NAME” and the first “NAME” field is, “Column A Row 1” in the database or spreadsheet, the cell in the webpage would reflect the correct value.
In this way, the webpage would never need to be modified. Any changes made to the supporting database would be reflected in the webpage. The idea is to have one person keep the database accurate,and never need to touch the webpage. We use this type of OLE (Object Linking Embedment) in documents to generate form letters.
I tried to use the Frontpage Web Database Wizard, but that does not seem to work. We do not need to add data to the database from the webpage at all. The actual web page design is being done in Dreamweaver. I have not worked with SQL, and I am looking for what I thought should be a simple solution. Is there a variable that I can place in the webpage to search for data in another place? What other options would work? Any help would be greatly appreciated.
