Displaying Data on a web page (dynamic)

[Suzanne]

Not sure how to describe this so someone can help but
here goes:

I have an html page that is like a catalogue for 3D
models. I have all of the meta data about the models in
an excel spreadsheet. I would like to create an html page
that has a list of all the models and when you click on
it, it opens the catalogue page, pulling in the specific
information about that model from the data source. I do
not want to have to create a hundred different pages I
just want one to update dynamically. I have no idea how
to do this so any assistance would be appreciated.

Thanks

 

[Kathleen Anderson [MVP - FP]]

Is your site hosted on a Windows server that supports ASP and Access and
running the FrontPage server extensions?

If so, I would recommend creating an Access database from the Excel
spreadsheet, and using the FrontPage Database Wizard to create the pages.

 

[Suzanne]

Yes - it will be running on the sharepoint server (at
least I think it is supported)

Silly next question:
How do I get it to just show the results of one record
(i.e. the one that the sales person chooses instead of
all of them).

Thanks

 

[Kathleen Anderson [MVP - FP]]

Create what I call a picklist, one page that displays a bit of information
from each record with a hyperlink for each record that lets the user display
more information on a second page:
http://www.spiderwebwoman.com/tutorials/picklist.htm