Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Transfer Access Database to MySQL

Options
  • 29-07-2006 4:34pm
    #1
    speedy21
    Registered Users Posts: 145 ✭✭


    Hi,
    I have a large Access Database with a lot of info in it...
    I'd like to upgrade to MySQL - because it's always crashing...
    Is there an easy way to transfer all the date from the Access Database?

    Many Thanks!


Comments

  • Options
    #2
    Robin1982
    Closed Accounts Posts: 323 ✭✭Robin1982


    Export the data to a flat file and use LOAD LOCAL INFILE to input. You'll have to create the tables first tho.

    Google Search is your friend.


  • Options
    #3
    osmethod
    Closed Accounts Posts: 244 ✭✭osmethod


    How large is your access database and what version?

    I have several 100MB-200MB Access 97 & 2003 DB's running in companies with upto 20 users accessing and no crashes????

    I might have to pointers to assist you...

    osmethod


  • Options
    #4
    preilly79
    Closed Accounts Posts: 627 ✭✭✭preilly79


    MySQL has an upsizing wizard which will take a look at your existing access database and create the relevant tables in a new MySQL DB, including moving all your data across. i think it's a seperate tool that can be downloaded from the MySQL site.


  • Options
    #5
    democrates
    Closed Accounts Posts: 2,046 ✭✭✭democrates


    He's right jack!
    http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-overview.html


Advertisement