« How to Soothe a Crying Baby
My Training Plan for a 2010 Gymnastics Competition »

Free MDB file to MySQL Conversion

December 4th, 2008 by Robert

This post has moved to http://www.wilycode.com/free-mdb-file-to-mysql-conversion - please go there for programming tips.

Related posts:

  1. How to import and export large datasets in mysqlThis post has moved to http://www.wilycode.com/how-to-import-and-export-large-datasets-in-mysql - please go there for...
  2. Source Control Feels GoodThis post has moved to http://www.wilycode.com/source-control-feels-good - please go there for...
  3. How to allow up and down arrows to navigate your form fieldsThis post has moved to http://www.wilycode.com/how-to-allow-up-and-down-arrows-to-navigate-your-form-fields - please go there for...
  4. How to enable SOAP on a LAMP serverThis post has moved to http://www.wilycode.com/how-to-enable-soap-on-a-lamp-server - please go there for...
  5. How to add special shipping by product in Zen CartAfter reading the instructions a few times I realized that...

This entry was posted on Thursday, December 4th, 2008 at 8:48 pm and is filed under Code. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

8 Responses to “Free MDB file to MySQL Conversion”

  1. chris Says:
    April 3rd, 2009 at 9:13 am

    i found the site useful

  2. Robert Says:
    April 3rd, 2009 at 9:47 am

    Thanks for the note, Chris

  3. Phil Says:
    March 10th, 2011 at 2:04 pm

    Wow, clear and effective, thanks a lot.
    I was looking for simple tools to convert a big MDB file to MYSQL and you just did it!

  4. Robert Says:
    March 10th, 2011 at 2:25 pm

    I’m glad you found it useful, Phil. Thanks for the note.

  5. ACES Says:
    June 12th, 2011 at 1:59 pm

    Chris, I am really glad I found this site.

  6. ACES Says:
    June 12th, 2011 at 2:31 pm

    Robert I apologize for Calling you Chris. Robert, the notes your wrote above were a great relief for me. Thanks alot.

  7. Robert Says:
    June 13th, 2011 at 10:10 am

    You’re welcome Aces - I’m glad you found it helpful.

  8. rp Says:
    January 5th, 2012 at 2:57 pm

    Hi,

    I was looking for the best way to transfer data from large MDB file (~2GB) to MySQL. The reason was poor full-text search speed of MS Access obviously. Your script helped me a lot. I would not probably find a way to connect to MDB using a COM object.

    A few notes (please correct me if I am wrong or inaccurate):
    1) ‘DefaultDir=C:\DataDir’ in connection string is redundant,
    2) ‘$rs->Fields(0)’ could be specified as ‘$rs->Fields(”FieldName”)’ which is a clearer way of specifying the source field,
    3) if anyone is going to process such a file one should cancel time limit for running the script as it is likely going to run for more than 30sec.: ini_set(”max_execution_time”, 0); set_time_limit(0);
    4) when inserting data to MySQL they should be treated with mysql_real_escape_string,
    5) If records in MDB are huge (>1MB) you will probably face a problem when inserting them to MySQL. You can get away with: mysql_query(”SET GLOBAL max_allowed_packet=1073741824″); - which sets the allowed size of inserted packet to max.

    Again, many thanks for the script.

Leave a Reply