Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 217
Shaman Avatar asked Feb 18 '12 10:02

Shaman


1 Answers

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.

like image 146
Kamil Avatar answered Oct 18 '22 22:10

Kamil