exceltodatabase

We have hosted the application exceltodatabase in order to run this application in our online workstations with Wine or directly.

Quick description about exceltodatabase:

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 can be

For detail, please see the document :
https: //github.com/ryjfgjl/ExcelToDatabase#readme.

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: Only need you provide the location of excels and the connect information of database, the tool can work until all the excels are imported
• Fast: Only 10s to import 10 excels completely, containing 10000 rows x 10 columns each of them
• Intelligent: When you manually import excel into database using tool like navicate, whether if you feel sad when error occurs? Baddly, other error occurs when you just fix one. 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.

Audience: Advanced End Users.
User interface: Windows Aero.
Programming Language: Python.
Database Environment: Oracle, MySQL, Microsoft SQL Server.

Categories: