0
I am trying to connect mySql
database on our server directly to an msAccess
database we have. I want to be able to download data from the mysql database
directly and upload it too directly. I want these things to happen between tables
.
For example, I have a table in Access called: tableA and in Mysql it is called TableAM. I want to be able to pull data to and from tableA to/from tableAm since they both corresponding tables.
How do I go about this. I am using MysQl 5.4
and MsAccess 2003
. Any ideas will be appreciated.