Choosing data source and destination
Choose a data source(destination)
In the first step of the Import/Export Wizard, it is necessary to state
the information about the data source and the data destination. All the
program needs to know about a database connection is written in two text
boxes. The program uses the so-called connection
string, which is, in fact, a line of text generated by the Data Link
Properties window.
When you click on the …button next to the description of each database
connection, the Data Link Properties window will be displayed. To find
out more, see Connect to existing
database.
If you choose a text file as your data destination, the ‘Configure text
file format’ option will allow you to define the way in which the data
will be written in that file. For more information, see Working
with text files.
Load package settings from a file
Downloads the previously saved package
into the Wizard and sets the options according to the data from the package.
Related Topics:
How
to export data into a text file
About Import/Export Wizard
About
exporting and importing data
Specifying the
type of the source data
Specifying source tables
and views
Specifying SQL statement
Column mappings
and destination table options
Completing the wizard
Working with text files
|