By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,500 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

How to Sync data between Access and Mysql tables?

P: 4
I have total 3 databases.One is mysql and other 2 are of access type.

I have 10 tables in each of the databases.
I want to sync 2 tables from both access databases with mysql tables.

whatever updates are happening in access databases tables it should come in mysql tables

1. student- table name
2. school - table name
both are in database 1
1. contact details - table name
2. departments - table name
in database 2

1. student
2.school
3.contact details
4.departments
all four tables with same structure is in mysql

i want to sync the access data in mysql tables.
Dec 6 '10 #1
Share this Question
Share on Google+
2 Replies


stepterr
100+
P: 157
Looking into how to link the databases. Here's a link that may get you started. http://itc.virginia.edu/desktop/web/mysql/msaccess.html
Dec 16 '10 #2

P: 4
I already know this method.I do not want to use it.In this my access data is the main data and people are using that database they will upload new stuff so I want mysql table to automatically get that data instead of me refreshing or doing anything.
Dec 16 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.