Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    6

    Question Software for converting files

    Hello, everyone.

    Does anyone know of a good software that can convert Access files to be compatible with MySQL?

    Any suggestion would be appreciated.

    Regards,

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by HaileyJ
    Hello, everyone.

    Does anyone know of a good software that can convert Access files to be compatible with MySQL?

    Any suggestion would be appreciated.

    Regards,
    An MDB file is a fairly complex structure. What parts of the mdb file?

    Tables and data?

    Queries?

    RI?


    I'm not aware of anything that could do VBA, macros, reports or forms.

    For simple requirements, possibly this module would suffice. (From within Access, it reads the Access table structure and generates SQL DDL which you can use to recreate the table structure on the server side. Then, you would link your access file to the new tables, and run a query to copy the records from the local table to the server-side table.

    I know that Navicat will import Access data into MySQL; I'm not sure as to the scope of what it supports.
    Last edited by loquin; 09-05-07 at 18:08.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Jan 2002
    Location
    Czech Republic
    Posts
    14
    HaileyJ,

    You can try our newly released DBConvert for Access & MySQL at http://dbconvert.com , which performs tables and data conversion.
    As well please look at http://www.dbconvert.com/convert-acc...-web-mysql.php . DBForms from MS Access to PHP + MySQL. It transfers MS Access forms to Ajax based web page driven by mySQL.

    Best regards,
    Dmitry,
    http://dbconvert.com

  4. #4
    Join Date
    Oct 2007
    Posts
    6
    If you're talking about importing the tables and data from Access to MySQL, i've found that MySQL's own Migration Toolkit does the job without any problems. It's an easy-to-use, step-by-step GUI.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    officeman, did you happen to read the thread? like, the post immediately before yours (posted a week ago)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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