With the help of this intuitive application you can easily import Excel spreadsheet data to your MySql databases, in new or existing tables.
- XlsToMy
- Version :3.1 Release 1 Build 170629
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
XlsToMy Description
If you are working as a database administrator, you probably spend a lot of time loading data from external sources. However, you can turn to specialized third-party software solutions that can simplify your work.
XlsToMy is one of the applications that can help you achieve quick, convenient results in the situation mentioned above by providing you with all the necessary tools.
Simple interface
This utility comes with a simple, user-friendly interface that encompasses various functions, which are neatly organized in its menus, making them highly accessible even to new users.
A detailed help manual is also provided so that you can consult it whenever you encounter difficulties understanding or operating some of its controls.
Connects to MySQL and SSH
After you launch XlsToMy, you are prompted to log in to a database before you can access the main window of the program. You can choose from MySQL or SSH connections by just clicking the corresponding tabs.
In order to establish a connection to your MySQL database, you need to provide the application with a host address, port, a username and a password. The database connection is saved to the Recent Databases menu so that you can access it quickly.
Imports Excel data to MySQL
You can turn to this application if you need to import Excel data to MySQL without significant efforts. After establishing a connection with your database, you simply need to load a suitable document from your computer by using the Import Excel function from the file menu. You can select the sheet and rows you want to work with after loading the file.
It is possible to create scheduled tasks and also generate a batch file that can be executed in Command Line by accessing the Save Session function from the File menu and defining the required parameters.
Lightweight Excel to MySQL import tool
All in all, XlsToMy is a handy application that enables you to import Excel data into your MySQL database with ease. It comes with a simple interface, packs intuitive functions, provides you with a detailed help manual and features support for scheduled tasks.