Оффлайн
- Регистрация
- 1 Мар 2015
- Сообщения
- 1,481
- Баллы
- 155
This article will introduce how to import Excel data into MySQL quickly and easily.
Preparation
Here, we prepare an Excel table, as shown below:
New Connection
Open the tool and create a new database connection firstly. Here we select MySQL database. For a detailed introduction to creating a new database connection, please refer to:
New Import
After creating a new database connection, click New Import
Start importing
Select the Excel file to be imported and click Start.
View Results
Optimization
As you can see, the table fields created by the default are all of the varchar type, which makes the import speed as fast as possible and avoids import failures caused by inconsistency between data and data types.
We can also let the tool automatically detect data types . The advantage of this is that the field type can be more consistent with the actual data and make subsequent SQL queries more convenient.
Select Rebuild Mode - Select Auto Detect, and click Start to re-import
See again
Save the import configuration
We can save the import configuration so that we can repeat the import next time.
You can see the saved import in the object interface or under the database connection on the left
Next time you open the software, first double-click the connection name to open the connection - double-click the import name to open the saved import.
Just click to start
About DiLu Converter
DiLu Converter is a powerful automated Excel import and export tool that supports more than 10 databases such as MySQL, Oracle, SQL Server, PostgreSQL, IBM DB2, Access, and Hive. The supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience of simplified Excel import and export, making Excel import and export easier than ever before. Whether you want one-click, batch, and personalized import and export, or want to use scheduled tasks to achieve unattended full automation, DiLu Converter can bring you unprecedented productivity improvement.
Go to
Preparation
Here, we prepare an Excel table, as shown below:
New Connection
Open the tool and create a new database connection firstly. Here we select MySQL database. For a detailed introduction to creating a new database connection, please refer to:
New Import
After creating a new database connection, click New Import
Start importing
Select the Excel file to be imported and click Start.
View Results
Optimization
As you can see, the table fields created by the default are all of the varchar type, which makes the import speed as fast as possible and avoids import failures caused by inconsistency between data and data types.
We can also let the tool automatically detect data types . The advantage of this is that the field type can be more consistent with the actual data and make subsequent SQL queries more convenient.
Select Rebuild Mode - Select Auto Detect, and click Start to re-import
See again
Save the import configuration
We can save the import configuration so that we can repeat the import next time.
You can see the saved import in the object interface or under the database connection on the left
Next time you open the software, first double-click the connection name to open the connection - double-click the import name to open the saved import.
Just click to start
About DiLu Converter
DiLu Converter is a powerful automated Excel import and export tool that supports more than 10 databases such as MySQL, Oracle, SQL Server, PostgreSQL, IBM DB2, Access, and Hive. The supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience of simplified Excel import and export, making Excel import and export easier than ever before. Whether you want one-click, batch, and personalized import and export, or want to use scheduled tasks to achieve unattended full automation, DiLu Converter can bring you unprecedented productivity improvement.
Go to