I need 2 MySQL databases created and populated with data from spreadsheets. I'm running version 4.0.23-standard. One spreadsheet will be provided for each database. A sample spreadsheet is attached that shows the layout of the data.
Both databases will reside on an Linux web server and need to be updated weekly from a link such as http://website.txt. The new data will need to be extracted from the webpage which will be the same layout as the database.
I need the updates to occur at a specified time and day of week programmatically. I also need to fire the update manually.
Thank you and good bidding!