This article will introduce how to batch import multiple or even thousands of Excel tables into a database.
Usage Example
As shown in the image below, I need to import all Excel files from the folder into the database.
Create a Connection
Here we take MySQL database as an example. After opening the DiLu Converter and connecting to the database, add a new import
Select Excel
There are two ways to select Excel files. One is to select the Excel file to be imported, and the other is to select the directory. If the directory is selected, all Excel files in the directory will be imported.
Method 1: Select file
Ctrl+A to select all Excel files, click Start
View the results:
Note that if a single Excel file contains multiple sheets, you can see that the table name is followed by the name of the sheet.
Method 2: Select the directory
Select the folder where Excel is located and click Start
Note: When selecting a directory, you cannot see the specific Excel file, you can only see the folder name. We just need to enter the folder where the Excel file is located and select this folder.
Subdirectory
We can see that there is a subdirectory called history under the directory. By default, the Excel files under the subdirectory will not be imported. If we want to import the Excel files under the subdirectory as well, we can check the option of traversing subdirectories under Excel options.
Optimize
As you can see, the default imported table names and field names are all from excel, some of which have brackets and other symbols, and the field types are all character types. If you want to create a table more standardized, you can adjust the options in the database options interface.
view result
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.
Top comments (0)