Import data from online Excel file to DB2 without programming

by

Want to parse online Excel file and save to DB2 ? Want to schedule and automate this converting task?

Using XlsToDB2, you can convert online EXCEL file to DB2 table easily and fast, and schedule and automate this converting task easily, no need to program, just a few mouse clicks!

Please download and install XlsToDB2.

Convert online EXCEL file to DB2 table

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

convert online EXCEL file to DB2 table - task window

Select “Source File From” with “Url”.

convert online EXCEL file to DB2 table - select type

then show the wizard.

1. Input the EXCEL file URL, and download the file.

convert online EXCEL file to DB2 table - download from EXCEL file URL

2. Open the saved EXCEL file.

convert online EXCEL file to DB2 table - open saved EXCEL file

3. Config target DB2 table.

convert online EXCEL file to DB2 table - config DB2 table

4. Summary.

convert online EXCEL file to DB2 table - summary

5. Convert.

convert online EXCEL file to DB2 table - convert to DB2 table

See DB2 table

convert online EXCEL file to DB2 table - view  DB2 table

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.


More about XlsToDB2 – the tool to convert online EXCEL file to DB2 table

30-day free trial Download XlsToDB2US$59.95 Buy XlsToDB2