Access-MySQL is an automation tool that can convert any Access database to MySQL and vice versa , it supports converting Table Relationships, the very essential feature that has always been missing in MySQL Converters world.
-Supports MS Access 97, 2000, XP, 2003, 2007 and MySQL 3.x, 4.x and 5.x.
-All common MySQL and Access data types and field attributes are supported
-Full support for converting indexes, Auto increment fields, composite primary keys and Constraints.
-Support converting table relationships.
-The ability to select only the tables & fields which you want convert.
-You can choose which records to convert through custom data filetrs. New
-Supports both local and remote connections to MySQL server.
-Support convert all white spaces or any special characters you choose in MS Access Database tables or field names to underscores "_" or any other character (s), for example, Automatically convert "Order Details" table to "Order_Details".
-Command line support.
-Support for scheduling conversion tasks to be performed automatically.
-Support for Synchronization, Adding new records or fields if any to the target table, Access to MySQL only. Also support updating the same record values.
-New Support for saving MySQL connection data so you don't have to enter them each time you run the wizard.
-Support changing all field names case to UPPER, lower or Capitalize first letter only
-Support for converting NULL values to "Zeros" for numeric fields and to Empty string "" for string fields.
-Support to control how the data type for Access "datetime" fields are handled for each table, Convert it to Date, DateTime, Time or Year.
-Support to choose whether to convert Indexes or not.
-Support to choose target table type for MySQL. MyISAM, InnoDB, Heep, ISAM or BDB.
-Introduces a new feature called Task Manager to enable you to manage your saved conversion tasks