Text Wizard dialog appears, with part of the contents of our log file
appearing as a sample, and the Delimited radio button selected by
default, as depicted in Illustration 6.
arrive at the second dialog of the Import Text Wizard, where we can view
a preemptory layout of the file, with the default selection of Comma as
delimiter type, and the quotation mark (") as the Text Qualifier.
We can scroll over and down to ascertain that the delimiting scheme is adequate
for our immediate needs. The second dialog of the Import Text Wizard appears
as shown in Illustration 7.
Because we wish to be able to use "dates as dates"
and "times as times" in our analysis of the log data later, we can
ensure that "translation" of the imported data to the correct data
types occurs here. This will save us the task of changing the data types (they
would largely be imported as text, by default) after creation of the table.
Click the Advanced
Specification dialog for our file appears. Here we can manage the data
type conversions that are enacted upon the text fields we import.
In the Field
Information table in the lower half of the Import Specification
dialog, type the titles from each Data Element column of Table 1
above into the respective Field Name column.
Change the Data
Type to Date/Time for the first two rows, Date and Time,
using the selector in the respective Data Type fields. Leave the
settings for this field at their defaults for the remaining rows.
Specification dialog, with our modifications, appears as shown in Illustration
Illustration 8: The Import Specifications Dialog
Import / Export Specification dialog appears. This offers us the
opportunity to save our data type specifications for re-use in subsequent
imports of the log file we are importing.
following into the Specification Name box of the dialog:
App Log Import Specification
Import / Export Specification dialog appears as depicted in Illustration
Illustration 9: Saving the Import Specification
returned to the Import Specification dialog, which now bears the name
that we have saved.
to return to the second dialog of the Import Text Wizard.
the In a New Table radio button is selected in the third dialog of the Import
Text Wizard that next appears, as shown in Illustration 10.
Illustration 10: Preparing for Creation of a New Table
fourth dialog of the Import Text Wizard appears next, as shown in Illustration
Illustration 11: Fourth Dialog of the Import Text Wizard