Import Excel To MySQL 3.1.1

Import Excel To MySQL 3.1.1 is designed as a powerful tool which can help you easily 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. Access-MySQL Converter, also provides you with a granular control over the conversion process like scheduling of conversion tasks, field selection , renaming of tables during conversion ,Command line support ,and many more advanced features.

It is the best and easiest way to transfer data between Excel and MySQL, complete with many advanced features such as columns / sheets selection, task scheduling so it could be performed automatically, ability to import new records only, ability to convert Excel to MySQL indirectly through a PHP dump file if direct connection to the target MySQL database is Not allowed , and much more, Try the free demo version to see how great this tool.

This useful tool can save you tons of your valuable time, and is suitable for both beginners and experienced developers alike

Major Features:

1. Supports MS Access 97,2000,XP, 2003 and MySQL 3.x, 4.x and 5.x.
2. All common MySQL and Access data types and field attributes are supported.
3. Full support for converting indexes, Auto increment fields, composite primary keys and Constraints.
4. Support converting table relationships.
5. The ability to select only the tables you want convert.
6. The ability to select certain fields for each table to convert.
7. You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database.
8. You can choose to convert both table structure and data or convert table structure only.
9. You can choose which records to convert through custom data filetrs. 
10. Supports both local and remote connections to MySQL server.
11. 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".
12. Command line support.
13. Support for scheduling conversion tasks to be performed automatically.
14. 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
15. Support for saving MySQL connection data so you don't have to enter them each time you run the wizard.
16. Support changing all field names case to UPPER, lower or Capitalize first letter only.
17. Support for converting NULL values to "Zeros" for numeric fields and to Empty string "" for string fields.
18. Support to control how the data type for Access "datetime" fields are handled for each table, Convert it to Date, DateTime, Time or Year.
19. Support to choose whether to convert Indexes or not.
20. Support to choose target table type for MySQL. MyISAM, InnoDB, Heep, ISAM or BDB.
21. Introduces a new feature called Task Manager to enable you to manage your saved conversion tasks.
22. Full support for different Character sets supported by MySQL 4.1 or higher New.
23. Ability to save conversion tasks for later use.
24. Conversion tasks now are saved in a new enhanced file format (*.amt) that saves all task related options for later use.
25. Task Manager is a new feature that allows you to view and manage your saved conversion tasks.
26. Data Filters is a very powerful feature that enables you to easily create custom data filters to convert only records that apply to those filters.
27. Enhanced support for converting table relationships.
28. You can choose the resulting Access database format (97, 2000-XP or 2003).
29. Enhanced logging capabilities to keep track of conversion tasks.
30. Enhanced Special characters support. You can select to replace any special characters either in database structure or the records with any characters you need.
31. Enhanced Synchronization support. Access-MySQL Converter now can update existing records of the target database if the target table has any unique row identifiers (Primary keys or unique indexes), This feature is supported when converting from Access to MySQL only.
32. Totally new and enhanced graphical user interface.