Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    8

    Unanswered: Convert MS Access to MySQL database

    Hi all.

    I have database in MS Access.
    I want to convert the database to MySQL.
    I have surfed the net that there are several ways to migrate data from Access to MySql, and the easiest is to buy a piece of software.
    And, other than that, we can use the MySQL odbc driver.

    I just wanna know, if there are any other way like using some script, example PHP script to convert the database?

    Can anyone here tell me the tutorial site that teach how to convert using PHP script ? or any other script that can do so?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    One simple solution is to load the MySQL ODBC driver onto the machine you currently use to manipulate your MS-Access database. You can then use the MS-Access GUI tools to create and manage your MySQL database.

    You can also make CREATE TABLE queries in MS-Access that will actually copy the data for you. These aren't terribly efficient, but with only 2 Gb of data in an MDB file, efficiency isn't all that important!

    -PatP

  3. #3
    Join Date
    Apr 2006
    Location
    Denver, Co. USA
    Posts
    242
    Take a look at the mysql Migration Toolkit from the authors of mysql - http://www.mysql.com/products/tools/migration-toolkit/

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Good point, but for one MS-Access database it might be overkill.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •