Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".


Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

DB2 Maestro online Help

Prev Return to chapter overview Next

Import Data Wizard

Import Data Wizard provides you with a graphical user interface to import data from the most popular files formats into existing DB2 tables. It allows you to adjust data formats, empty target tables, execute custom SQL scripts, etc.


Import Data tool supports:

Microsoft Office Excel 95-2003
Microsoft Office Excel 2007
Microsoft Office Access
Microsoft Office Access 2007
Delimiter-separated values (CSV, DSV, TSV)
Text files
ODBC data sources (any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc.)


In order to run the wizard you should


open the table in Table Editor;
go on to the Data tab;
select the Import Data item from the Navigation Bar.


To import data,

Set the format of the input data and the source file name;

See also: Export Data Wizard



Prev Return to chapter overview Next