Withdata Software

Import data from online Excel file to DB2 without programming

Want to parse cloud Excel file and save to DB2 ?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can convert cloud EXCEL file to DB2 table easily and fast.

Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import cloud EXCEL file to DB2 table

Choose DB2 and logon.

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

Select “Source Type” with “Url”.

then show the wizard.

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

2. Open the saved EXCEL file.

3. Config target DB2 table.

4. Summary.

5. Import cloud EXCEL file to DB2.

See DB2 table

Import cloud Excel to DB2 in command line

Save “Excel to DB2” session, then you can:

Set scheduled tasks for importing Excel to DB2

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ

How long does it take to import cloud Excel to DB2?
FileToDB works fast. It convert millions of rows within a minute.
Is it safe to import cloud Excel to DB2 using FileToDB?
Of course! FileToDB import cloud Excel to DB2 locally, absolutely safe.
Can I import cloud Excel to DB2 on Linux, Mac OS?
Yes, you can. FileToDB has Linux, Mac OS, and Windows version.
Can I import cloud Excel to DB2 in command line?
Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.
Can FileToDB work without Microsoft Excel installed?
Yes, FileToDB can work without Microsoft Excel installed.