Confused!

[green'n'white]

Hi,

For my football team website I have a stats excel file where the starting team, subs and goal scorers are entered with totals being added up at the end of the table.

I have linked these results to another excel file saved as htm to provide a stats page on the site. What I would like to do is add stats to individual 'player profile' pages from this main spreadsheet.

Obviously the player profiles would need to automatically update for time reasons , hopefully from just saving the main spreadsheet. So what I am asking is, Can indiviual cells be extracted from the xls file directly into each webpage?

Please bear in mind that I have absolutely no idea where to start with regards any db.

thanks.

[phpnovice]

Sure, with ASP you should be able to open the Excel spreadsheet and read it like any other database. The following would be your connection string:

"Driver={Microsoft Excel Driver (*.xls)};DBQ=" & Server.MapPath(RelativePath & FileName) & ";ReadOnly=1;"