Advice updating MS Access data to remote MySQL host that only allows local access

I wonder if anyone has any ideas? As I can't just run an update locally and connect to the remote MySQL host, I was scheduling a periodic export of an access table to csv format, ftping it to the server, and then running an update script on the remote host (simplehost.com). It just seems convoluted, and frought with difficulties. There has to be a easier way to update the transaction status table? Hmmm -Brian Anderson