DBConvert for MS Excel & MSSQL

DBConvert for MS Excel & MSSQL is a reliable bi-directional database migration tool which allows you to convert from:

• MS Excel to MS SQL
• MS Excel to MS SQL Dump
• MS Excel to MS Excel
• MS SQL to MS Excel
• MS SQL to MS SQL
• MS SQL to MS SQL Dump

You can convert your entire .xls file to MS SQL or select definite ranges of data from MS Excel spreadsheet to create as many tables as you want. Integrated Data Selector is meant to simplify your work for source choosing. Operate with the whole database or select only needed MS SQL tables and fields, indexes and foreign keys to proceed. Reach the desired result by simply configuring only several options through Wizard-like interface or in command line mode! DBConvert for Excel & MS SQL is also applicable for MS SQL database migration to another MS SQL database or convert Excel database to another Excel file.

As you know the conversion speed depends on different things: the source file size, the computer performance, the output settings and so on. Now you don't need to search any tips to speed up the conversion. To increase conversion speed we improved our engine for large databases, with approximately 500 thousand records and more. Now they can be converted in 30-40 min.

Features
• Microsoft SQL Server Express 2005/2008 and Microsoft SQL Server 2000/2005/2008 support
• Interactive (GUI) mode / command line mode;
• Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
• Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support.
• Interactive (GUI) mode / command line mode;
• Saving data into a MS SQL Dump for export to MS SQL database;
• Data mapping - simple data types' assignment for a destination database to match one data type to its closest equivalent in the target fields;
• Automation of the conversion process with built-in scheduler;
• Primary keys and Indexes support;
• Foreign 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.
• Skins support;
• Multilanguage Support;
• 1-year free upgrades.
• Office 2010 support

Requirements | Convert MS Excel to/from MS SQL
• Microsoft Excel 2000 or higher
• Necessary privileges to write into database on the target MS SQL server
• Excel 97/2000/2003/2007/2010
• MS SQL 2000/2005/2008/2012/Express
• Microsoft Visual C++ 2008 x86 Redistributable package