One-click Importing Excel Data into a*Database
Just 1-Step to Import Excel into Database
Today, we will share a simplest method to import Excel into Database, which allows you to do so in just one step.
Preparation
As shown in the picture, we have prepared an Excel spreadsheet called ‘Customer Info’
Create a Connection
Open DiLu Converter, click Connection and choose your database such as MySQL. If you don’t have this tool yet, you can download it from HERE.
It is a professional automation tool for importing and exporting Excel. And for other database connection, you can view New Database Connection Guide.
Begin to Import
Just Select your Excel file and click Run. Let’s Go!
View Result
Optimize
By default, the tool automatically generates the table name based on the Excel file name and the sheet name when importing, and generates the field name based on the table header name. The field type defaults to varchar. Because Excel name and header names contain spaces, which will cause inconvenience to subsequent queries. The data type can also be set according to the Excel column type.
So we can adjust options as below:
See again
More Detail About DiLu Converter:
Documentation: https://medium.com/@ryjfgjl.zhang/di...n-05a50a8d0daa
Download: https://sourceforge.net/projects/exceltodatabase/
Today, we will share a simplest method to import Excel into Database, which allows you to do so in just one step.
Preparation
As shown in the picture, we have prepared an Excel spreadsheet called ‘Customer Info’
Create a Connection
Open DiLu Converter, click Connection and choose your database such as MySQL. If you don’t have this tool yet, you can download it from HERE.
It is a professional automation tool for importing and exporting Excel. And for other database connection, you can view New Database Connection Guide.
Begin to Import
Just Select your Excel file and click Run. Let’s Go!
View Result
Optimize
By default, the tool automatically generates the table name based on the Excel file name and the sheet name when importing, and generates the field name based on the table header name. The field type defaults to varchar. Because Excel name and header names contain spaces, which will cause inconvenience to subsequent queries. The data type can also be set according to the Excel column type.
So we can adjust options as below:
See again
More Detail About DiLu Converter:
Documentation: https://medium.com/@ryjfgjl.zhang/di...n-05a50a8d0daa
Download: https://sourceforge.net/projects/exceltodatabase/