Data Loader

In This Chapter

The Data Loader is a flexible and powerful tool for loading data into your tables. Start it from the Database Explorer, menu Tools > Data Loader (or use the Data Loader icon).

The Data Loader is part of the Extended Edition of AQT, which is a separately purchasable component of AQT. If you have not purchased the Extended Edition you can still use the Data Loader, however you will not be able to load more than 100 rows.

Within the Data Loader window:

in the top section, specify the destination table
select the data source on the Source tab
on the Mapping tab define mapping instructions to manipulate the data and build load specifications
set general load options
set the error handling options
the buttons at the bottom run/cancel/preview the load.

You can save/retrieve the load specification using the menu: File > Save Load Options and Open Load.