SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Convert access db to mysql?

    I'm looking for some sort of app, tool, macro or other that would let me convert an Access db into a mySQL database.
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes

  2. #2
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can use AccessDUMP, that converts the Access DB into a usable SQL schema dump. AccessDUMP is a free GUI-based application, and can be downloaded here:

    http://www.intranet2internet.com/public/default.asp

    Once you have converted the Access database to an SQL schema file, then you can use phpMyAdmin to upload the file, using the "Run SQL query/queries on database - textfile" feature on your phpMyAdmin database table listing page.
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!


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
  •