I am trying to have my access database export a specific table to a database located on a different server.

We want to be able to send data from our access database to our web designers MySQL database, but here is the tricky part. We want our access database to be able to send this data to the other database (not housed on any of our servers) every 30 min or so to keep the designers data that they are using updated consistently.

Is there any solutions for this?

That is a simple solution, but do you know of any tutorials or any help with that. Setting up the MySQL database is easy, but not sure how to create the macro to export to the other database every 30 min.