SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Addict joyce's Avatar
    Join Date
    Aug 2001
    Posts
    295
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    convert records in access to mysql

    hi there,

    can anybody tell me how to convert records in access into mysql??

  2. #2
    SitePoint Enthusiast
    Join Date
    Apr 2002
    Location
    Ohio
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use the Save as/Export function in Access '97 to export the database to a text file. Then I use the import function in PHPmyadmin.

    If you are using Access '97 and need detailed instructions let me know.

  3. #3
    SitePoint Member
    Join Date
    Jul 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool

    There is a free tool "DBTools" for Windows which can convert databases from Access to MySQL. It has it's WEB site somewhere in Brazil. You can download it from

    http://www.dbtools.com.br/

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've used DBTools before and it's nice. Best thing is through a CSV though. I like it much more. Course if it's a really big db then it could pose some problems....but then again, if it's a really big db, Access probably can't even function.

    Sketch
    Aaron Brazell
    Technosailor



  5. #5
    SitePoint Wizard Goof's Avatar
    Join Date
    Feb 2001
    Location
    Pittsburgh, PA
    Posts
    1,154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could also create a ODBC record for the MySQL database and then use the File -> Export function in Access. The last choice in the file type drop down is an ODBC datasource. In theory this should work fine.

    Hope that helps,
    Goof
    Nathan Rutman
    A slightly offbeat creative.


Bookmarks

Posting Permissions

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