1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I'm a newbie to mySQL so I'm hoping somebody could help me by shedding some light on converting Access dbs to mySQL. I know there are scripts available, but some help maybe on getting them to work?
  2. #2
  3. No Profile Picture
    Iharizaka Rahaingoson
    Devshed Newbie (0 - 499 posts)
    Check out for the Access VBA script at http://www.cynergi.net/exportsql/. It would be too long to include here. I dit not test it myself yet. It should work under both Access 97 and 95. Otherwise, see also MySQL command LOAD_DATA_INFILE for loading text files.
  4. #3
  5. No Profile Picture
    Sumeet Sharma
    Devshed Newbie (0 - 499 posts)
    try and copy the access database as an txt file...(cut and copy from the browse mode)...now u will have ur data in the space seperated form...use the load data infile syntax in MYSQL to load file...
    u can also use the exportsql file mentioned above...u have to use it as an macro...
    it will create a mysqldump.txt which u will ahve to execute in mysql...
    both the ways r good ...thougth u may try teh previous one for fast transfer...

    [This message has been edited by Sumeet Sharma (edited 11-01-99).]

Similar Threads

  1. mysql - MS access linked tables has locked me from changing anything
    By alexmasters in forum Database Management
    Replies: 2
    Last Post: May 15th, 2004, 04:17 AM
  2. convert access to mysql: new scenario
    By bugga in forum MySQL Help
    Replies: 2
    Last Post: November 24th, 2003, 04:09 PM
  3. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  4. mysql and access 2k..some questions
    By hescominsoon in forum MySQL Help
    Replies: 0
    Last Post: June 28th, 2003, 07:38 PM
  5. ACCESS Requests to MYSQL
    By kiddo01 in forum MySQL Help
    Replies: 4
    Last Post: June 18th, 2003, 04:45 AM

IMN logo majestic logo threadwatch logo seochat tools logo