How to import information to a MySQL Database ?

Posted on 2011-10-26
Last Modified: 2012-05-12
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?

Question by:dimensionav
    LVL 82

    Accepted Solution

    No, there is also MySQL Workbench .  Here are some instructions for import/export between MySQL and MS Access:
    LVL 2

    Assisted Solution

    one that i really like is

    it is a paid program though but i've really liked it.
    LVL 11

    Assisted Solution

    Use the below software access to mysql
    LVL 7

    Expert Comment

    by:Vimal DM

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    The viewer will learn how to dynamically set the form action using jQuery.
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now