Free download XlsToMy

XlsToMy

2.3
XlsToMy - Import Excel to MySQL easy and quickly. Main features: 1. Automatic match tables
Free Download
User rating
8.8/10
8 votes
License
Shareware
OS
Windows
Developer
Version
2.3
File size
5.7 MB
Language
English
Release date
22 December 2014

Editor's review

This is a data conversion tool that helps DBAs and database programmers import Excel data to MySQL database.

XlsToMy will help import Excel data to MySQL easy and quickly. The software tool makes it easy to get data from Excel sheets. The interface lets you set up the correspondence initially. In fact, a wizard takes you through the complete setting up of a session. These session parameters can be saved and run again and again. That is a handy feature when such transfers are done repeatedly, perhaps daily. Wizard lets you set up the MySQL schema; table details etc. and define what data fields are to be imported from the spreadsheet. When the actual transfer is happening you get a clear idea of how much data has been transferred. The indications include a progress bar of course. Besides, it has a percentage transfer completed display. Number of record transfer out of a total number and time elapsed and time remaining indications are also available on the progress bar.

All data types handled by MySQL database are supported including text and BLOB types. The tool also supports Unicode so that all kinds of text, in Asiatic or even Arabic could be supported. Data imported can be previewed and that can be a tool to ensure you have defined everything correctly and data has been imported correctly. To save the IT department a lot of hassles, this tool offers scheduling and thus the ability to get regular transfers done automatically.

Publisher's description

XlsToMy - Import Excel to MySQL easy and quickly. XlsToMy is a data conversion tool that helps database user to import Excel data to MySQL.
Main features:
1. Automatic match tables and fields.
2. Batch import from multiple sheets at one time.
3. Import and see result, immediately.
4. Save configuration and run repeatedly, command line, scheduled task.
5. Wizard - step by step, or Direct import - efficient.
XlsToMy
XlsToMy
Version 2.3
Free Download

User comments

Rate this program