Awesome q2a theme

How to export data from MS Access?

0 like 0 dislike
43 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 | 43 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

Related questions

0 like 0 dislike
3 answers
MS SQL and export from it?
asked Mar 28, 2019 by nDiviD
0 like 0 dislike
1 answer
How to solve the problem of exclusive access to MS ACCESS?
asked May 21, 2019 by avpdnepr

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,187 answers
0 comments
40,796 users