ExcelToDatabase: batch import excel into database automatically
What is it?
ExcelToDatabase is an automatical tool which can batch import multiple excel files into database(mysql/oracle/sqlserver/postgresql/access/hive/sqlite/dm). Automation is its main feature beacuse the tool can import data into database automatically and no need you to provide a mapping. Batch is the another feature beacuse of automation, so you can import 10 or 10000 excels one time but not one by one. Scheduler make you can import excel to database at any time.
Features
Automation
Based on the excel, the tool can create table and import data into the database automatically, or just append/merge the data based on the automatical mapping between the excel and databases.
Batch
Usually you only can import excel one by one using the other tool. But now, you can import all excels you want one time.
Easy
You only need to provide the location of excels and the connect information of database, the tool can work until all the excels are imported
Fast:
The fastest, no others
Intelligent:
When you manually import excel into database, whether if you feel sad when error occurs? DO NOT WORRY! The tool can deal with them!
Advanced:
Rich options could be custom choose to make more fuction come true.
Schedule:
You can make a schedule using it on windows/linux.
Realtime
Sync data in excel into database in realtime.
Security
DO NOT connect to internet. Work on offline to protect data
Where to get it
The packaged executable program(ExcelToDatabase.exe on windows) is available,
you can download it from sourceforge.
Download
Usage
Start Program ExcelToDatabase.exe
Choose and Input
Choose the directory or excel files;
Input target database information;
Click Start
Supported Environments:
Windows/Linux/Mac
MySQL/Oracle/SQLServer/PostgreSQL/Access/Hive/SQLite/DM
Excel(xls,xlsx,xlsm,csv)