Database Convert for Excel & MySQL

BUY NOW/DOWNLOAD DEMO | More Conversion/Migration/Forms/Sync Products & Demos

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made HERE or the Buy Now button below. Send order# [email protected] 31 days after purchase.

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

You can convert your entire .xls file to MySQL 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 MySQL 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 & MySQL is also applicable for MySQL database migration to another MySQL database or Excel data migration to another Excel file.

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.

High speed data conversion and performance
Try it now and make sure that its true! DBConvert for MS Excel & MySQL establishes a direct connection to source and destination databases. Thanks to improved quality of conversion, data is transferred much faster and more accurate in comparison with lots of others converters. It is developed exactly for solving your problem with minimum effort and time!

Preverification of possible conversion errors
Verify possible conversion errors before the conversion process gets started! To prevent is better than to correct! Our tool displays errors and potential problems with your table objects beforehand. Some errors that could bring to the conflict on a destination database are easy to eliminate by a small reconfiguration of the conversion process issues in one touch.

Conditional data migration
Manage your database conversion with the help of integrated data filters. Define filtering conditions and retrieve only the specific data that you need for conversion. Due to our data filters you get more control on data migration process.

Workaround problems with firewalls and access rights
Use our workarounds as MySQL Dump and PHP Script if you don`t have a direct access to MySQL server! MySQL Dump can be used if you have no direct access to MySQL server, but can execute SQL-scripts, for example through phpMyAdmin or other tools. PHP Script is used if you dont have a direct access to the MySQL server, but have an ftp and PHP access. DBConvert for MS Excel & MySQL generates a PHP-script that contains database info inside and can be executed on the server to put database there.

Full UNICODE architecture support
DBConvert for MS Excel & MySQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.

Savable sessions
Save your sessions and use them again if you do not want to loose time for configuring source, destination database and other customizations for conversion process.

Command line mode
Run DBConvert for MS Excel & MySQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.

Flexible Scheduling
Raise the productivity of your work up. Conversion and synchronization task managing is performed in all DBConvert tools with built-in Scheduling stage. Using sessions and batch files as parameters the scheduled tasks will automatically work as services in background mode giving you an opportunity to keep them unattended.

User-friendly interface
User-friendly interface is the outcome of the combined efforts of our team in the field of software usability plus Graphic User Interface design. Working with the converter is specially 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.

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);
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.
1-year free upgrades.

Requirements

Windows Vista/XP/2000/NT (NT only with Internet Explorer 4.01);
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 ).

Important notices

Does not convert system (hidden) tables.

BUY NOW/DOWNLOAD DEMO | More Conversion/Migration/Forms/Sync Products & Demos

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft