Import data from online Excel file to DB2 without programming

by

Posted on by

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

Using FileToDB, a native GUI tool, 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 FileToDB.

Convert online EXCEL file to DB2 table

Choose DB2 and logon.

convert online EXCEL file to DB2 table - Choose DB2 and logon

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

convert online EXCEL file to DB2 table - task window

Select “Source Type” 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 FileToDB – the tool to convert online EXCEL file to DB2 table

30-day free trial Download FileToDB