Export information from XLS files to DB2 database format and enable SQL queries to view the importing results using this application.
- XlsToDB2
- Version : 2.9 Release 1 Build 170629
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
XlsToDB2 Description
XlsToDB2 is a software utility that facilitates a user-friendly interface for importing information from Excel spreadsheets to save data in DB2 format. It has simple steps for server configuration, support for Unicode, and it enables users to save sessions and load them at a later time to pick up where they left off. Command lines are supported too, in addition to a task scheduler for automatization.
To get started, it’s necessary to configure server settings, such as the type of protocol (TCP/IP or standard), hostname, port number, database name, username and password. Unicode can be either enabled or disabled.
In the following step, information from Excel spreadsheets can be imported into the main app window using the popup file browser, after which tables can be selected to configure fields. During this time, users may preview data as well as create log files to study any errors occurred during the task.
It’s possible to run SQL queries, create and manage scheduled tasks (e.g. allow task to be run on demand, force stop running task, stop if switches to battery power) as well as create batch files. Moreover, sessions can be saved to file in case users wish to repeat the same tasks.
System requirements
- DB2 database
Limitations in the unregistered version
- 30 days trial
- Nag screen