I have data on a local system I would like to have fed to MySql on the fly as the local data chages often and I don't want to be stuck "uploading" a batch CSV file into the table. I have the database also tied in locally through ODBC. Should I have an access file query locally and then send data or is there a more acceptable way about approaching this issue.
Thanks