Retrieving data from Excel

[alexanderdring]

Hi everyone,

Thanks for the help with my last post. I was wondering if anyone knew how to retrieve data from excel spreadsheets and display them in HTML form boxes? I'm not sure I have the terminology quite right, but in short, I'd like to create a form where someone can type in a PRODUCT NUMBER:

PRODUCT NUMBER: -----------

TYPE: -------------

POWER SUPPLY: -----------

etc.

and have all of the information related to that product (TYPE, POWER SUPPLY) appear in boxes on another page. Is that ASP? It would also be great if it could happen the other way around, so if they type in POWER SUPPLY, the closest PRODUCT NUMBER to that figure would appear in the same way. I hope that's clear. Any help would be greatly appreciated because I'm going roung in circles!

Alex D.

 

[tviman]

Questions....

1. Is this an intranet form/excel spreadsheet?
2. If #1 = no, do youplan on this being available online?

Above answer(s) will dictate how you implement the solution.

There's always a better way. The fun is trying to find it!

 

[alexanderdring]

Hi tviman,

At present, I intend to put it together off-line as a CD-based technical source. This would seem to suggest option one and hopefully be a little easier compared to putting it on the web, which is a long way in the future of this project!

Thanks again.

Alex D.