Erm.. Databases and auto updates

[MrDatabase]

Hi

Please forgive me if I don't do a very good job of explaining this. I have quite basic html knowledge and no flash / asp / or dynamic html knowledge whatsoever so any help would be much appreciated.

I've been asked by my manager to design a website that will automatically update from an excel spreadsheet.

A spreadsheet is created every week by HR which shows a list of Duty managers, times working, contact numbers etc.

Is there a way that when this spreadsheet is created I can just copy the excel file to my web folder and the website will read from the file and automatically display the new information?

Thanks in advance

[moojoo]

Easiest way I can think of is to export the spread sheet to a csv file and insert it into a MySQL database assuming the spreadsheet/database have the same structure it will work and only take a minute to perform. I use CocoaMySQL to do this and it works perfectly every time, PHPmyAdmin can probably do it too.

[Ryan Fait]

If you spend a little time (a few hours tops), you should manage to understand PHP with mySQL enough to acheive this. http://phpfreaks.com/ is an extremely helpful and active forum for poeple new to PHP (and they're almost all mySQL experts too).