7

How to import Access 2010 database (.accdb) into MySQL. For example, I want to import my Product inventory database.accdb fully, how can I do that easily. Thanks.

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
Shaman
  • 83
  • 1
  • 2
  • 4
  • Googling `How to import Access 2010 database (.accdb) into MySQL` shows a lot of promising hits – Pekka Feb 18 '12 at 10:39
  • 2
    I have used this tool before - http://www.bullzip.com/products/a2m/info.php. It is also easy to use ODBC to connect Access directly to your MySQL db and then copy data between them. – user1191247 Feb 18 '12 at 10:49
  • 1
    I used Bullzip for a while. I was very satisfied. But not anymore; it is giving me an error when I press "import". The error is very common (Error 50: File already open), many people posted the issue on the official web site but no one replied. – Nadjib Mami Apr 26 '13 at 17:18

1 Answers1

7

There are many ways.

You can export Microsoft Access tables to CSV file and import that file in MySQL (little complicated but fastest way).

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

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

Kamil
  • 13,363
  • 24
  • 88
  • 183