Database Tour Documentation Contents Index

Importing Data

Top Previous Next

To import data from a certain data source into a certain table of opened database, use Import button or the corresponding item from Tools menu.

It is possible to import data from another table or query of the currently opened database, or from a table of external database. As a target, already existing table can be used or import can be done into a new table which is created "on the fly" during the import procedure.

Steps of importing data into a new or existing table of the opened database:

1. Choose Tools | Import Data... menu or click the Import button on the tool bar. To import from a table from the current database, in the table list, right-click the table you wish to import data from, then choose Import Data from <TableName>...

2. Select the data source. It can be a table of an external database as well as another table or query of the currently opened database. Click Next.

3. Specify the name of the target table and select desired import/export options (described in Exporting Data topic). Click Next.

4. Specify source-to-target field mappings and click Import. This step can be skipped (if you click Import instead of Next at the previous step); in this case the program will build the filed mappings implicitly. But it is recommended to specify the field mappings explicitly for existing target tables, and the corresponding fields in source and target must have compatible types.

See also

 Dragging / Importing Files

 Exporting Data