Forum Moderators: mack

Message Too Old, No Replies

Using Excel data within a web page.

Can someone help me import the data.

         

panaceapeace

2:23 pm on Jul 20, 2005 (gmt 0)

10+ Year Member



I have list of words with meanings in excel sheet. 1000 or more words

I nead to create a home page which takes the question number from the user. Then it would display the word and choices and submit button. Once user selected the choice it would say correct or wrong and go to the next word?

How can this be done?

Thanks In advance

maxi million

3:42 am on Jul 21, 2005 (gmt 0)

10+ Year Member



hi

i see no one has answered your query so far. i was hoping someone would give you an EXCEL..lent answer :)

so here is my little inexpert reply:
first of course youll need to consider using server side scripting, which is to say use php,asp,perl etc to do the things you want to use. in effect your pages (ie programs) need to do the intelligent work. have you already decided on this?

alex77

12:28 am on Jul 22, 2005 (gmt 0)



Hm, MS stuff not really being my line of expertise, I'll give it a try nevertheless:

If you want to keep your data in the Excel format, you'll need to go with ASP. MS supplies ODBC drivers for excel format, so you should be able to code a database-like connection using ASP code. Then you can query your excel file and use the data to dynamically generate pages.

If you want to use a different language on the presentation layer, like PHP, you'll have to consider a different database. Depending on what your hosting company offers, you can go for a real database (like mySQL) or a delimiter-separated file.

maxi million

3:40 pm on Jul 22, 2005 (gmt 0)

10+ Year Member



alex77
very neatly put!

:)