I am using a redhat server with php and mysql. I was wondering if there is a way to automate a download of an excel spreadsheet from another webserver convert it to csv and import it to a mysql table?
Hey Export it to a csv file and then use PHPmyadmin for example to put it in to the database. Or use the mysql command to input csv-file.
the keyword here is "automate". I need something to do it everyday for me. even if I am not here.
