# 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\Exc elToDatabase\ma in.py
Way 2: Send an email to (Moderation - redacted email), 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
## 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\Exc elToDatabase\ma in.py
Way 2: Send an email to (Moderation - redacted email), 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