Sync offsite mySQL table with local Access Table

[tobymom]

Dear Experts,

I am a novice VBA coder and been googling this w/o any luck.

Can this be done?

Let's say there's a mySQL server running on
host: xyz.com
DBname: myDB
table_name: tblA
(and login/pw etc...)

Then there's local Access DB with the same table name/structure.

Can they be synchronized with VBA with two buttons?
Button1: Synch from mySQL > Access
Button2: Synch from Access > mySQL

 

[jrbarnett]

Yes, quite easily both ways - look at the SQL Code for an insert query.

I'd also consider taking a backup of the old data before emptying the table (on either side) and loading the new data in.

John