|
|
|
| Downloads: 812 |
 Tell us about an update
|
 |
|
User Rating:
Rated by: |
Good (3.0/5)
2 user(s) |
|
|
|
DBConvert for MS Excel & MySQL description
|
Converts Excel datasheets to MS SQL database
DBConvert for Excel & MS SQL is a strong utility that allows you to convert their Excel and MySQL databases.
The user can convert data 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 and MS SQL to MS SQL Dump. You can convert your entire .xml 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 choosing a source. Operate with the whole database or select only needed MS SQL tables and fields, indexes and foreign keys.
Reach the desired result by simply configuring several options through a 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 Excel data migration to another Excel file.
Control the process and conversion priority with a built-in scheduler that makes the program launch according to the jobs you schedule. The ability to connect to MS SQL database servers located on all Unix-like and Windows machines can be considered as one of the tool's main advantages.
The user-friendly interface is the outcome of the combined efforts of our team in the field of software usability plus Graphic User Interface design. Work with the converter is divided into several stages so the most complex issues of the conversion process are broken down into manageable parts. All documentation is provided with the software for your convenience. Here are some key features of "DBConvert for MS Excel & MySQL":
· 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.
· 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.
· `ENUM` and `SET` MySQL database types support.
· Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
· Skins support.
Requirements:
· Microsoft Excel 2000 or higher
· At least 32 MB of RAM
· 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 ).
· MySQL 4.x/5.x
Limitations:
· It converts only the first 50 first initial records for each database. What's New in This Release: [ read full changelog ]
· Languages support added
· Improved database engine
· Variable quantization step added
|
|
Find us on Google+
