Access Connect To Remote MySQL Db (1 Viewer)

[CharlesWh]

My system needs to connect to another database (MySQL) to periodically pull some data across and update some tables in my Db.

I'm looking for some advice as to the best method to accomplish it programatically. Thanks.

 

[HiTechCoach]

My system needs to connect to another database (MySQL) to periodically pull some data across and update some tables in my Db.

I'm looking for some advice as to the best method to accomplish it programatically. Thanks.

If the database is set up to allow remote access, you can install the mySQL ODBC driverand create a linked table(s). Now you can process the mySQL table(s) like any other linked table(s).

Also see:

mySQL links

Hope this helps ...

 

[CharlesWh]

Many thanks for the reply. Based on your advice I have found that actually its really not that hard. Thanks.