English | File size: 24.4 MB

Our DBConvert for MS Excel and MSSQL is an application designed for converting Microsoft Excel spreadsheets into Microsoft SQL Server/ Windows Azure SQL Databases and vice versa.

The Integrated Data Selector helps you to simplify your tasks of choosing data ranges in .xls/.xlsx spreadsheets (semi-)automatically. You can convert your entire Excel workbook or select discrete ranges of data from a MS Excel spreadsheet in order to create several tables in new or existing database. DBConvert for Excel and MS SQL is also suitable for database migration between two SQL servers/Windows Azure SQL Databases or even two Excel files.

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);

MySQL tables conversion into different Microsoft Excel sheets;

Primary keys and Indexes support.

For keys support.

Advanced customization options:

- partial selection for database objects to be converted.

- database objects (tables, fields, indexes) renaming before conversion.

- detection of possible conversion errors at customization stage.

Sessions support - all your settings can be saved and restored then.

`ENUM` and `SET` MySQL database types support.

Ability to connect to MySQL database servers located on all Unix-like and Windows machines.

Skins support.

Updates: official site does not provide any info about changes in this version.