SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Zealot mdavis1982's Avatar
    Join Date
    Mar 2004
    Location
    Stoke-on-Trent
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Converting Access 2000 to MySQL

    Hi all...

    I am currently developing a website for a company and they have provided me with their current database in Access 2000 format. I am redesigning their site to use MySQL and PHP and I was wondering what the best way is to convert the data?

    I can't hand enter all the values because there are about 11,000 of them, and obviously that would take me weeks!

    Thanks for the help in advance...

    Matt

  2. #2
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have a look at www.navicat.com, it has an import function from access. Its a little pricy, but if you only going to do it once or so, there is a 30 day trial.


  3. #3
    SitePoint Zealot mdavis1982's Avatar
    Join Date
    Mar 2004
    Location
    Stoke-on-Trent
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks...

    I tried going there and their site appears to be down. Also, I'm on Mac OS X, so will it work on there? I've got a feeling I'm going to have a problem with the import because I've got a feeling their current database is a bit 'messy' and isn't referenced properly...

    Is there any way of just importing certain columns into the database into a certain row in the MySQL version? Grrr.... I wish customers would maintain a database properly!

    He he...

    Thanks for the help again,

    Matt

  4. #4
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yup, works on Mac: http://mac.navicat.com/

    Trust me, this app will do everything you need. I used to to transfer data from one MySQL database to another, which has columns added, remove and changed. It has a ton of options for importing/exporting and its fast.

  5. #5
    SitePoint Zealot mdavis1982's Avatar
    Join Date
    Mar 2004
    Location
    Stoke-on-Trent
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cool, thanks...

    Dunno why the site didn't work before! It works now! I'll have a look at it as soon as I've got the database design sorted out and written some php and stuff!

    Thanks for the info! :-)

    Matt

  6. #6
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, dhtmlgod.

    I am also doing an Access to MySQL conversion process, although, the application work is in ASP.NET.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  7. #7
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Great!!!

    I downloaded Navicat - ran an import from my Access file - all 24,000+ records across 24 tables imported without an error! What's really cool is that now that the database/tables are created, I can run imports just to sync the data to keep the new database up-to-date with the old until we switch over. The only drawback was that the primary keys and auto-increment didn't work, but no biggie.

    I think this is well worth the price to buy for management and future updates.

    Thank God I came across this post before spending an all-nighter writing scripts for the import process!
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com


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
  •