MS Excel to MySQL Migration

Software for database transformation that can help you to perform data migration between two sources - MS Excel spreadsheets and MySQL Server.  It'll let you send your data directly from MySQL database to MS Excel .xls and .xlsx files and back from MS Excel spreadsheets to MySQL database.

The tool selects entirely source database for conversion by default. In case you need only some tables, just deselect the ones you don't need.  Every MySQL table is converted to one Excel sheet and inversely – one Excel sheet to one MySQL table. 

The application is extremely easy to use and fully adaptable to the needs of different users as it has many customizable options.  A useful feature of this product is that you don’t need to monitor it constantly to check your conversion and synchronization. The Build-in Scheduler and Command Line Support will do the database transfer for you in the automated mode.

Extract data to an Excel file or to MySQL database is an excellent solution for databases that have large amounts of data as both MS Excel and MySQL possess many useful capabilities and features for organizing data.

There is a possibility to import  MS Excel data to MySQL Dump file or to PHP script to overcome the limitations on MySQL Server.

This software was designed to transfer data between MySQL tables and MS Excel sheets quickly and neatly and to simplify the process of data conversion as much as possible.

Read here trial versions limitations

Product highlights

• Ability to create tables from MS Excel file with Integrated Data Selector
• Microsoft Excel 2000 or higher 2003/2007/2010
• Views conversion from MySQL to MS SQL and Oracle and back support
• Saving data into a MySQL Dump and PHP script for export to MySQL database
• Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
• Speed conversion with Bulk and Quantization features
• Also see common features for all DBConvert tools

Requirements

• Necessary privileges to write into network shared folder (LAN or VPN) where destination database Excel resides
• Microsoft Visual C++ 2008 x86 Redistributable package
• Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)