View Image

DBConvert for MS Excel and MSSQL is a tool designed for conversion spreadsheets from Excel to MSSQL/ SQL Azure database and vice versa. Integrated Data Selector helps you to simplify your work for .xls/ .xlsx source choosing.

Excel to MSSQL, MS SQL Dump
MSSQL to Excel, MS SQL Dump
Excel to SQL Azure
You can convert your entire Excel spreadsheets or select definite ranges of data from MS Excel spreadsheet to create as many tables as you want. DBConvert for Excel and MS SQL is also suitable for database migration between two SQL servers or two Excel files.

FEATURES:

· Interactive (GUI) mode / command line mode;
· Saving data into a MySQL Dump, PHP script for export to MySQL database;
· Saving data into a MS SQL Dump for export to MS SQL database;
· Foreign key (relations) support;
· Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
· MS SQL Server 2000/2005 support.
· 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 built-in scheduler;
· Field mapping - simple data types' assignment for a destination database to match one data type to its closest equivalent in the target field;
· Ability to select table types when copying data to MySQL or MySQL Dump;
· Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support;
Unicode Support/Connection character sets for MySQL Server 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, UTF8 (unicode charset).