|Previous Top Next|
( Pro Edition )
The Data Import Wizard - Tools | Import Data - is an easy to use tool to import file data. To import data that can be accessed via ADO or ODBC, better use the Data Pump tool which has a lot more possibilities.
Current the following formats are supported for data import:
The first thing you need to do is select a source format and file.
The Data Import Wizard - file and format selection
The options you get when clicking the Next button are dependent on the format selected.
The DWX format will show you the tables in the file and let's you select which tables to import.
The CSV format shows a dialog like below:
The Data Import Wizard - csv import options
The preview grid displays the data according to the settings used.
The grid is also used to select what columns to import and to link them to columns from the table selected in the Into table part. After you have selected your columns, click the Finish button to start the import.
See also: File and Folder Boxes