ExcelToDatabase

Bref: A tool which can batch import multiple excel files into mysql/oracle database automatically.

Pictures：

Features：

Batch Automation:

Import multiple excel files under directory one time

One-Click:

Do not need to do anything until all excel files are imported.

High Speed:

Most quickly tools like this around the world.

Inteligent:

When come across some durty data or some difference between Excel and Database, tool can deal with it and go on.

Advanced Options:

Rich options could be custom choose to make more fuction come true.

Free:

Most important thing.

Usage

1.Start Program

Way 1: Command: python D:\Projects\ExcelToDatabase\main.py

Way 2: Send an email to 2577154121@qq.com, you can get an exe program which can directly run on windows.

2.Input Information

Select directory with excel files; Input target database information; Choose import mode.

3.Click Start.

Tested Environments:

Windows 7+, MySQL 5.6+/Oracle 11g+, Excel 1997+(xls,xlsx,csv)

Options Detail:

General：

Excel：

Directory: The excel files under this directory would be imported

MySQL/Oracle Connection:

options to connect to database

Mode:

Overwrite: drop table first(if exists); create table; insert data.

Append: just insert data into table(table needs exist in the database)

Advanced：

CSV Encoding：

Tools can auto-detect encoding of csv files(default), and you can choose or input other value.

Replace To NULL：

values populated will be replaced to null.

Add Table Prefix：

The value populated will be added to table name before.

Append all data to one exists table：

Under Append mode, import all data to the table populated.

The Column on row：

Set which row as Column name.

Skip Blank Rows：

Skip Blank Rows

Trim Spaces：

Trim spaces on data.

Skip Blank Sheets：

Ignore if no data.

Include Sub Directories

Find all excel files under the directory Include Sub Directories

Others：

How to define table name：

file name + '_' + sheet name(if one excel has multipule sheets)

How to define column name：

Default is the first row

How to define column type：

Varchar(255) is default. If max length of column more than 255, text will be set.

How to deal with mysql error 1366：

Auto Correct

How to deal with mysql error 1118：

All column will be create as text

Author: ryjfgjl

Send email to 2577154121@qq.com for help.