Select load source

Use the left pane of the Source Tab to select the type of data to be loaded, then specify the source on the right.

Four types of data source can be specified:

File	data is in a structured file (such as .csv)
Excel worksheet
Table	data is in another table	The table can be on a different database, but you must be connected to it in AQT
Query	data is in a query	The query can be run on a different database, but you must be connected to in AQT.

File

specify the name of the file by using the Browse button or the drop-down list of recent files.
You can browse/edit this file by clicking on the Edit button. This opens the file using Notepad.
Alternatively, you can view the contents of the file by clicking on View. The file is split into "fields" according to the delimiters you have specified; this makes it very easy to view the contents of a structured file. It also enables you to see a particular record-number (which is useful if you are getting an error loading a particular record).
Column Delimiter specifies the character that delimits separate fields in your file. If you have a tab-delimted file, enter the word tab in this field.
String Delimiter specifies the character that encloses string values in your file.
First Line has Column Names specifies that the first line in your file has column names, and not data. If you want the load to bypass more than the first line, see Start from Row on the Options tab.

Excel worksheet

specify the name of the file by using the Browse button or the drop-down list of recent files.
once you have selected a file, Excel will be activated and AQT will fetch the list of worksheets in this Excel file. These will be displayed in the worksheet dropdown list. Select the worksheet containing your source data.
once you have selected a worksheet, the active cells in the worksheet will be displayed in the worksheet Active Area boxes. You can change these values to change the cells that you want loaded into your table.
clicking on View will show you the worksheet data. Go back to the previous section for the description of this function.
First Line has Column Names specifies that the first line in your file has column names, and not data.
sometimes Excel gets into a strange state: it will be running but not visible. Use the Activate Excel button to make Excel visible.

Table

select the table by using the Browse button or the drop-down list.
select the database from the Database drop-down list.
Use same schema and table name as target table and Use same table name as target table are useful when you are loading data into many tables. These will automatically set the table name when you select another target table. When Use same schema and table name as target table has been specified, the source schema and table name will be set to the same as the target schema and table name. You might use this, for instance, if you are copying data between tables with the same names in different databases. When Use same table name as target table is specified, only the source table name (and not schema name) is set to the same as the source table. You might use this, for instance, if you are copying data between tables in two different schema in the same database.

Query

Enter the query into the Query text box (copy and paste the SQL from your query), and select the database from the Run query against database drop-down list.