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

MySql -> MS Access

Options
  • 10-06-2009 11:48pm
    #1
    Peter B
    Registered Users Posts: 1,086 ✭✭✭


    I can't seem to be able export mysql database to a type that MS Access will understand.

    Anyone know how to transfer the database my mysql to MS Access?


Comments

  • Options
    #2
    cracker
    Registered Users Posts: 197 ✭✭cracker


    If you download TOAD for mysql from Quest (The mysql version is free) there is an export wizard that lets you choose from a number of options for the output format, including an access database file. I haven't used this option myself but worst case scenario you can export to excel and then import these using the Access import wizard


  • Options
    #3
    seamus
    Registered Users Posts: 68,317 ✭✭✭✭seamus


    Download the MySQL ODBC connector and then you should be able to connect to MySQL from Access and import the relevant tables.


  • Options
    #4
    Saint_Mel
    Registered Users Posts: 2,598 ✭✭✭Saint_Mel


    You can add them as a Linked table if you have the ODBC set up


  • Options
    #5
    RangeR
    Registered Users Posts: 7,265 ✭✭✭RangeR


    +5 for ODBC between both.


Advertisement