Live Data to MySQL

[harvillo]

This is a very newbie question as I have never attempted to do so but... Let's assume I have an excel document on my personal desktop which is updated daily via an internal program via ODBC. As opposed to saving and uploading the file twice a day to my MySQL DB I would like a process or job to upload the data at a regular intervals so I can ensure all data is accurate. Is there a front-end or other procedure that you recommend?

[konsu]

is there an OS that you prefer to use on the machine that maintains the spreadsheet?

[veridicus]

I would write a script (PHP, Python, etc.) to upload the spreadsheet to MySQL and set up a scheduled job (cron on *nix) to run that script. You should be able to connect to the spreadsheet from a scripting language with ODBC, just like your internal program.

Or you can write VBScript in a spreadsheet that connects to MySQL through ODBC and pushes the data to it. If you set the script to run automatically when the spreadsheet loads then you can schedule a job to load the spreadsheet.