Import each sheet in an Excel file to a separate DB2 table

by

Want to import data from each sheet in an Excel file to a separate DB2 table?

Try Withdata FileToDB, a desktop Excel to DB2 converter for Windows, MacOS, and Linux, Convert Excel to DB2, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Import data from each sheet in an Excel file to a separate DB2 table

Login to DB2 -> Select Excel worksheets -> Set DB2 tables -> Excel worksheets to DB2 tables

Choose DB2 and logon.

import data from each sheet in an Excel file to a separate DB2 table - Choose DB2 and logon

Click “Wizard – 1 File To N Tables” at task dialog.

import data from each sheet in an Excel file to a separate DB2 table - task window

Select the “Excel” file type.

load each sheet in an Excel file to a separate DB2 table - select file type

then show the wizard.

1. Open Excel file, select worksheets.

import data from each sheet in an Excel file to a separate DB2 table - select worksheets

2. Show existing DB2 tables, choose “Import Type”.

import data from each sheet in an Excel file to a separate DB2 table - choose import type

3. Set DB2 tables.

import data from each sheet in an Excel file to a separate DB2 table - set tables

4. Show summary, set “Convert Rows”.

import data from each sheet in an Excel file to a separate DB2 table - summary

5. Import data from each sheet in an Excel file to a separate DB2 table.

import data from each sheet in an Excel file to a separate DB2 table - import data

View imported data in DB2 table

import data from each sheet in an Excel file to a separate DB2 table - view data


More about Excel to DB2 converter

See Video: Import each worksheet in an Excel file to a separate DB2 table at one time