Excel MySQL converter 3.1

Excel MySQL converter 3.1 is a tool for extracting Excel files into a MySQL database and  MySQL to Excel, which also offers other useful features including command line, task scheduling, sheets and columns selection, ability to append only new records to the target mysql database, etc.

Excel MySQL converter supports all Excel and MySQL versions and it can convert Excel to MySQL indirectly through a PHP dump file if direct connection to the target MySQL database is Not allowed . Try the free demo version to see how great this tool

Why Choose Excel-MySQL Converter :

• Save your time and effort:
• • The simple interface of Excel-MySQL Converter makes it much easier for you to get up and running in just a few seconds. No need to waste you valuable time trying to figure out where to start or reading any help files, Excel-MySQL Converter interface is extremely intuitive, Just follow the wizard screens to get your database converted.
• Do it once and let Excel-MySQL Converter do it forever:
• • If you need to convert from mysql to excel or vice versa , on time-based schedule then Excel-MySQL is the one for you. With its new enhanced Scheduler, Excel-MySQL enables you to schedule the whole conversion process to be automatically performed according to a time-based schedule.
• Able to work even when remote connection is not allowed:
• • One of the good features of the converter is that it can store your Excel file in a PHP script, by running it once on your server you will be able to import your Excel file to your target MySQL server even if remote connection is denied.
• Bidirectional conversion (MySQL-MS Excel)
• • Excel-MySQL Converts any MySQL database to Excel and vice versa, unlike other similar data migration tools, which commonly perform only one-way conversion.
• Be in control:
• • Excel-Mysql support many advanced options that makes you control the whole conversion process , you can choose certain tables to convert and moreover you can select certain fields from each selected table , You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database.

Major Features:

1. All versions of MS Excel are supported
2. All versions of MySQL are supported
3. Supports both local and remote connections to MySQL servers.
4. Ability to convert any Excel file into MySQL directly or  indirectly via a PHP script if remote connection to your MySQL server is denied for any reason
5. Ability to schedule the conversion tasks to be performed automatically.
6. Very easy to use wizard style interface
7. You can choose either to create a new MySql database, or append your tables/records into an existing one.
8. The ability to select only the tables which you want to convert.
9. The ability to select only the columns which you want to convert from each selected table .
10. Ability to append only new records to an already existing table
11. Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets
12. Command line support.
    • You can run Excel-MySQL from the command line ,This  would bypass the wizard and make it very easy for computer-illiterate folks to do the conversion with a double-click
      
13. Support for saving MySQL connection data so you don't have to enter them each time you run the wizard.
14. Full install/uninstall support
15. Great Support Service
16. One year of Free Upgrade

• Scheduling of the conversion tasks to be performed automatically.