Specifying source tables and views
Use this dialog box to specify the tables and view to be copied to the
destination.
Source
Shows the tables and views that are available for copying to the destination.
If you select a source and perform no other action, you will copy the
schema and data from the source without changes.
Destination
Sets the destination tables. The wizard automatically matches source
and destination tables or views if it can detect the objects with the
same name in the destination database. If it does not find the match,
it encloses the name of the source object in between brackets ([]) to
indicate that the new table should be created in the destination database.
You can edit the name of the destination table by clicking on its name.
Transform
Displays the Column
mappings and destination table options dialog box, where you specify
which destination columns are to receive source data, edit their data
type, and specify the options for creating the destination table.
Related Topics:
 How
to export data into a text file
About Import/Export Wizard
About
exporting and importing data
Choosing data source
and destination
Specifying the
type of the source data
Specifying SQL statement
Column mappings
and destination table options
Completing the wizard
Working with text files
| 
