curiouscat.com > code > MySQL

Import Data:
Code: MySQL, database

MySQL (great open source freeware database) includes a great data import tool: MySQL Migration Toolkit - simple videocast tutorial. Importing from Microsoft Access tips:

• I have had problems when a password is on the access database. If that is the case just remove the password from Access (you must open the access database in exclusive mode and then use the tools-security settings to remove the password).
• Access bit fields will import as 0 for false and -1 for true. So you might want to update all -1 to 1.
• It is a good idea to check the field datatypes (and varchar sizes, etc.) to be sure the field information all came over correctly. The date fields in Access might be turned into varchar fileds in the automated import. So just be sure to check and updated the field type to date in MySQL (the data should import fine).