Results 1 to 9 of 9
  1. #1
    Join Date
    May 2007
    Posts
    139

    Unanswered: If I have an Access DataBase how to convert to MySQL

    If I have an Access DataBase how to convert to MySQL?
    I have to export sql file and to import mysql?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there used to be a tool called dbtools whi9ch was free and did the job
    ...looks like there still is

    I don't think the mySQL migration toolkit (part of the MySQL GUI tools) available fromt he MySQL website does it but you may want to check

    failing that its an export from MySQL to a CSV file and import into MySQL.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2007
    Posts
    139
    by "MySQL to a CSV" you mean Access, ?

    I want the structure of db (or and data in) trasfered: Access->mysql?

  4. #4
    Join Date
    Sep 2010
    Posts
    1
    I used dbtools in the distant past and it worked well on a simple Access Database. DBTools Software - Welcome to DBTools Software

    It was reasonably priced and simple to use

  5. #5
    Join Date
    May 2007
    Posts
    139

    MAY VIA ACCESS get make an .sql file of the schema, and after import it to MySQL

    MAY VIA ACCESS get make an .sql file of the schema, and after import it to MySQL?

  6. #6
    Join Date
    Mar 2004
    Posts
    480
    you may find that you need to make some changes to the data types but otherwise that could work. try it and see.

  7. #7
    Join Date
    Sep 2010
    Posts
    3
    I've been looking for an alternative to M$Access for the last few weeks solid.

    Kexi from Koffice is supposed to be able to open data tables and convert them to another format from an MDB file. Haven't tried this yet. OOO Base can't. Datakiosk is unmaintained. SQLyog can't. MySQL Administrator can't. phpMyAdmin can't.
    Kexi can't yet do composite primary keys though but you might be able to convert using Kexi and then access the resulting MySQL db with something else.

    I'm next going to look at using MySQL Administrator to create my db and xataface to create the queries, forms, reports etc in php but it looks like I have to learn SQL to code some stuff.
    HTH
    Max

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try the MySQL migration toolkit
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Sep 2009
    Posts
    64
    If I were you, I'd install MySQL ODBC connector. Then from Access, create new database pointing to your MySQL (using ODBC). Then from within access, import from another access file.

Posting Permissions

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