Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Location
    Thane, Maharashtra,India
    Posts
    17

    Unanswered: hOW TO CONVERT MYSQL DB into MS Access

    Please guide me how to convert MYSQL database into MS Access?

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    Tools

    Try to export sql commands for the creation of the table (or make them manually) and export the data (with mysql tools) and import data to access

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Or use one of the tools that can read both formats such as dbtools (www.dbtools.com.br)

    Do you actually need to move the data into MySQL format - you can read MySQL tables in access over ODBC, and (I think even as linked tables)

  4. #4
    Join Date
    Jul 2004
    Location
    Dundee, Scotland
    Posts
    107
    re the database data: for simplicity, setup your MySQL database as an ODBC source, then create a new MS Access database and use the MS Access wizards to import the table data.

    re the database front end: you have to start from scratch (or employ someone) to re-create the front end in MS Access.

Posting Permissions

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