• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

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
0
dimensionav
Asked:
dimensionav
3 Solutions
 
Dave BaldwinFixer 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
 
chemdryCommented:
one that i really like is http://www.webyog.com/en/

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

http://www.bullzip.com/products/a2m/info.php
0
 
Vimal DMCommented:
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now