How to import information to a MySQL Database ?

We need to import information to a mysql from an access database, how could we do that?
Is only PHPMyAdmin the only GUI to manipulate this kind of databases?

Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
No, there is also MySQL Workbench .  Here are some instructions for import/export between MySQL and MS Access:
chemdryConnect With a Mentor Commented:
one that i really like is

it is a paid program though but i've really liked it.
kelvinwkwConnect With a Mentor Commented:
Use the below software access to mysql
Vimal DMSenior Software EngineerCommented:

1) From access DB,there is an option to covert that entire table as excel
2) After converting into excel,write a php script to read the excel and insert into mysql DB
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.