In our work, we often need to import Excel data into Access for data analysis and processing. Usually we use database tools like Navicat or the Excel import function in the editor that comes with the database to manually import it. However, it is not easy for both professional and non-professional data processing personnel to correctly import an Excel file into a database.
Now, through years of practice, we have solved various problems through the DiLu Converter tool, achieving one-click import of Excel into the Access .
DiLu Converter is an automated tool that can import Excel files into a database in bulk.
Support for 6 common formats of Excel files (xls/xlsx/xlsm/xlsb/csv/txt) and 8 database types (mysql/oracle/sql server/postgresql/access/hive/Access/dameng).
Let's take an example of importing a product information table into a Access database.
Now, we can import it to the database with 1 step through the DiLu Converter tool.
Create a new database connection
Click on the toolbar (New Connection) to select your database type. Here, we will use Access as an example. To create other database connections, please refer to the DiLu Converter New Database Connection Guide.
Add a configuration
1 Step to import: Select the file to import and click "Start"
Finally, enter the database editor to view the import results
Top comments (0)