when i create a link between the Access Database and Mysql, is there any way the table data in Mysql will be automatically updated from the Access database after exporting the first time?
My Access table is updated every hour. How can i synchronize the transfer of data between the two database?
i have similar problem. i created a ODBC link from the access database using the import option. but the problem is the access file is fetching data from the mysql database. but i want to send data from access to mysql. :( how do i do that?