Workflow: To Import a File Using a Wizard
This section describes the steps for using a wizard to import a file. This workflow assumes that you have already created a wizard that you can use for importing a particular file type.
-
Invoke the Text Import Wizard Command.
-
Specify the type of data the file contains (Data Type).
-
Choose a wizard to use for importing the file (Wizard Name).
-
Click OK to import the file.
-
Choose the File > Text Import Wizard command.
The Text Import Wizard dialog appears.
-
With Wizard Name set to < New >, specify the appropriate Data Type and the name of the file you want to import.
-
Click OK.
The Text Import Wizard - Step 1 dialog appears.
-
Set the Lines within Range or Lines within Relative Range to specify which lines in your file contain the actual data.
-
Click Next.
The Text Import Wizard - Step 2 dialog appears.
-
Define how to apply filters, define original data type, and review defined filters.
-
Click Next.
The Text Import Wizard - Step 3 (Fixed Width) dialog appears.
OR
The Text Import Wizard - Step 3 (Delimited) dialog appears.
Which dialog appears depends on the original data type you defined on the Text import Wizard - Step 2 dialog.
-
Provide require information for the defined data type.
The Text Import Wizard - Step 4 dialog appears.
-
Define the contents of each column of data in the file that you are importing.
-
Click Finish.