How to export data from MS Access?

0 like 0 dislike
14 views
Could you please solve the following question:
There are about 10 tables in Access with daily data since 1990, which are updated daily with new data.
How can I make a Mysql table in automatic mode daily updated with new data from the corresponding Access tables?

If I had to only update one table in Mysql, it would not be difficult, but when there are more 10 - it's wrong.

Please give me advice how to do it...
Thank you in advance!
by | 14 views

3 Answers

0 like 0 dislike
by
0 like 0 dislike
It's not exactly what you need.
We are talking about independent with no direct ties tables in access and mysql. Ie in mysql has a table that is automatically updated with new records from access.

In other words, if someone deletes aksenovsky database, all data will still be in mysql.

Perhaps as a solution to this issue, you can use the mysql event.
by
0 like 0 dislike
It remains only to consider the opposite scheme: when data is stored directly in the mysql tables linked to access. And even though amudalavalasa accessasia files. :).
by
110,608 questions
257,186 answers
0 comments
33,949 users