Geek Answers Handbook

How to import Access 2010 database (.accdb) into MySQL

How to import an Access 2010 database (.accdb) into MySQL. For example, I want to completely download the product inventory database .accdb, how can I do this easily. Thank you

+5
source share
5 answers

There are many ways.

You can export Microsoft Access tables to a CSV file and import this file into MySQL (a bit complicated, but the fastest way).

You can install MySQL ODBC driver and mount MySQL tables in access

You can save / export the .accdb database to the old access format and find the tutorial for the old version.

+5
source

MS Access MySQL , MS Access:

MS Access MySQL

enter image description here

+1

MySQL ODBC- MySQL, , !

MySQL ODBC http://dev.mysql.com/downloads/connector/odbc/

0

sqlyog , ODBC. mysql odbc .

0

If you are on Mac OS or Linux, mdbtools is great. With just a few lines on the command line, you can convert .accdb or .mdb files to .sql and other formats, ready to be imported into your mysql database. This tutorial very clearly explains the process https://www.codeenigma.com/community/blog/using-mdbtools-nix-convert-microsoft-access-mysql

0
source

More articles:


All Articles