Want to import data from multiple Excel files to a single DB2 table?
Try Withdata FileToDB, a desktop Excel to DB2 converter for Windows, MacOS, and Linux, Convert Excel to DB2, Easy and Fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Import Excel to DB2 locally and privately, avoid uploading Excel file(s) to online services.
- Support Windows, Linux, and macOS.
Import data from multiple Excel files to a single DB2 table
Login to DB2 -> Choose Excel files -> Set DB2 table -> Import multiple Excel files to DB2
Choose DB2 and logon.
Click “Wizard – N Files To 1 Table” at task dialog.
Select the “Excel” file type.
then show the wizard.
1. Select a folder that constains Excel files.
2. Config first EXCEL file importing options.
3. Select a DB2 table and config fields.
4. Preview data will be in DB2 table.
5. Import multiple Excel files to a single DB2 table.
View imported data in DB2 table
More about Excel to DB2 converter
Download Withdata FileToDB
See also:
