#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    73
    Rep Power
    15
    Does anyone know how to import MS Access databases (.mdb) into mysql
    Thanks
    Des
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Den Laeghe Landen
    Posts
    107
    Rep Power
    15
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by des:
    Does anyone know how to import MS Access databases (.mdb) into mysql
    Thanks
    Des
    [/quote]
    Export table from MS-access into a text-file.
    maybe you need to adapt it a little bit (add quotes around strings etc.)
    but this is only possible if there aren't too many data.
    read the text-file into mysql

    Another way (if you often have to import data, or a lot data):
    make a php-script, which reads the text-file (or paste the text into a variable) and make php read it line-by-line, and parse it at the separation-tokens used in the files (komma or tab, etc) with explode or implode (see php-man) and for each line insert int into your table.

    Good luck!

    EyE



    ------------------
    --
    ...tiktak...tiktak...
    --
    ...Tommyknockers, Knocking On Your Door...

Similar Threads

  1. Wap database access
    By Efti in forum Mobile Programming
    Replies: 0
    Last Post: August 21st, 2003, 09:50 AM
  2. Problem displaying an image from my database
    By Dark Escence in forum PHP Development
    Replies: 1
    Last Post: May 15th, 2003, 01:24 PM
  3. import database
    By neversummer in forum MySQL Help
    Replies: 7
    Last Post: November 16th, 2001, 12:32 PM
  4. Replies: 3
    Last Post: July 10th, 2001, 07:11 AM
  5. how to import a '.sql' file to mysql database?
    By aloha in forum PHP Development
    Replies: 1
    Last Post: July 10th, 2001, 02:54 AM

IMN logo majestic logo threadwatch logo seochat tools logo