Specifying source tables and views
Use this dialog box to specify the tables and view to be copied to the
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.
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.
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.
to export data into a text file
About Import/Export Wizard
exporting and importing data
Choosing data source
type of the source data
Specifying SQL statement
and destination table options
Completing the wizard
Working with text files