Php event calendar with mysql support

[karl584]

Does anyone know that is it possible to make mysql database table read data automatically from excel file. The excel file is also updated everyday but the names stay same. I would want to make it update the data itself from the file everyday or when the calendar is opened togheter with the homepage.Somebody told that it can be done while access is the middle connector but isnt there a straighter way or....
Thank you in advance for your answers.

[kurby]

I would use a scheduled task that parses and inserts the CSV data into a database. If you create a script in PHP then this could be triggered with a Cron task or on the opening of a page or any other website action.

[aj_nsc]

Do what kurby said....

Create a PHP script that parses your excel file - it must be saved as a format that can be parsed - CSV, or if the spreadsheet needs to be a little bit more complex, XML. Then, also as kurby pointed out, if it doesn't matter to you when the database gets updated, set the script as a cron. Or if it does matter to you, then run the script every time some action is performed (e.g. the calendar is viewed).

No need for access or anything like that, PHP and an excel document in the proper format can handle it all.