DBConvert for MS Excel & MySQL is a reliable bi-directional database migration tool which allows you to convert from:
MS Excel to MySQL
MS Excel to MySQL Dump
MS Excel to PHP Script
MS Excel to MS Excel
MySQL to MS Excel
MySQL to MySQL
MySQL to MySQL Dump
MySQL to PHP Script
Convert databases from MS Excel to MySQL or from MySQL to MS Excel rapidly and reliably! Operate with a whole database or select only needed sheets, tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBConvert for MS Excel & MySQL is also applicable for MySQL database migration to another MySQL database or to MySQL server. Moreover, DBConvert for MS Excel & MySQL is quite well for copying MS Excel database to another MS Excel database.
Safe data conversion and database integrity
Don`t care about safety of your data. Our converter will do it for you! DBConvert for MS Excel & MySQL supports all MySQL server data types (including `BLOBs`, `ENUMs`, `SETs`). Primary keys, indexes and foreign keys are supported in the best way.
Features
Interactive (GUI) mode / command line mode;
Saving data into a MySQL Dump, PHP script for export to MySQL database;
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
Automation of the conversion process with Task Scheduler;
Ability to select ISAM, MYISAM, HEAP, innodb or BDB table types when copying data to MySQL or MySQL Dump;
Ability to create tables from MS Excel file;
Unicode Support/Connection character sets support: LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, Hebrew, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);