#1
  1. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Okay, first time in doing something like this, I need to get an Access database into mySQL..

    Is there an simple solution to this, does MS Access give me the ability to export the database into an "SQL" file??

    With all the structure and data intact?

    In short, I'm looking for a quick way of gett ing all the data out of Access and into MySQL for use on the web..

    Any help would be quite appreciated.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  2. #2
  3. No Profile Picture
    RyanP
    Guest
    Devshed Newbie (0 - 499 posts)
    i have done this, but instead of spending time to find a "simple" solution for this i just exported the tables to a tab delimited text file and then wrote a simple php script to read in the data and store it in a mysql db

    this was pretty quick and easy, but if there is some kind of "accessdump" feature, i would love to hear about it too
  4. #3
  5. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Well, I'd go that route, but since I don't know much about Access, and I didn't create this database, I'm not even sure what the current database structure is... So creating a the tables would would make it a bit difficult to simply use the CSV data.. I dunno..



    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  6. #4
  7. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    The MySQL website has a page of links to third-party software and utilities at
    http://www.mysql.com/information/links.html

    The one you want is called ExportSQL, at
    http://www.cynergi.net/exportsql/

    This is an Access module to dump an Access database into mysql-readable script, including table drop, and create, and it even (mostly) handles type conversion. You might have to edit the resulting SQL file for certain column type conversions, but it's generally right on the money.
  8. #5
  9. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks for the link and the response.

    I've downloaded the text file from the site, but I'm still not really sure "how" to use it.

    It obviously contains scripting data, and it says it's a module for Access.. But, alas, I'm not all the familiar with MS Access, at any capacity.

    Any pointers?

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  10. #6
  11. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Open your Access Database, in the tabbed window that lets you choose Tables, Queries, Forms, etc... choose Modules. Click the New button on the right, paste in the code from the script, close, and you will be prompted to save the module. Once saved, just double-click on the module icon, and it will run the dump.
  12. #7
  13. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Thanks for the feedback, I had figured it out. Not a real complicated process, but one might have thought that MS would have just created the program with the export for SQL files.

    But that would have made just too much sense and meant that MS would have had to play nice with others.



    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    73
    Rep Power
    15
    had major problems with access but found the best way to convert a TABLE was to export as text .txt from MSAccess
    open in wordpad remove the top line (the field names) strip the " quote marks.

    then create the table in mysql
    then run this
    mysql> LOAD DATA INFILE "data.txt" INTO TABLE your_table;

    Make sure you u to your database.

    This is only good for tables hope its some help

Similar Threads

  1. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 05:11 PM
  2. Can't access the database info!
    By Axsuul in forum PHP Development
    Replies: 5
    Last Post: February 11th, 2004, 01:22 AM
  3. From Access to remote MySQL
    By TimMatthews in forum Database Management
    Replies: 0
    Last Post: February 3rd, 2004, 10:54 AM
  4. Replies: 0
    Last Post: January 30th, 2004, 09:46 PM
  5. database type: mySQL, MS SQL and Access
    By vinyl in forum ColdFusion Development
    Replies: 5
    Last Post: January 27th, 2004, 08:25 PM

IMN logo majestic logo threadwatch logo seochat tools logo