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?

Regards
dimensionavAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
No, there is also MySQL Workbench http://www.mysql.com/products/workbench/ .  Here are some instructions for import/export between MySQL and MS Access: http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-examples-tools-with-access.html
0
 
chemdryConnect With a Mentor Commented:
one that i really like is http://www.webyog.com/en/

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

http://www.bullzip.com/products/a2m/info.php
0
 
Vimal DMSenior Software EngineerCommented:
Hi,

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
0
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.