Import Data Tool
The Import Tool allows users to import data from delmited files, Excel spreadsheets, or fixed width files into database tables.
Import Options
Parse File Line By Line: Select this option if the data being imported does not
contain line breaks. This option causes the Import Tool to look at the delimited
file line by line and then break each line up based on the delimiter.
Parse Entire Contents of File: Use this option if there are line breaks contained in
the data to import. This option requires a one to one mapping between the columns
to import and the delimited values.
Delimiter: Select or enter the delimiter used to separate values in the file.
Delimited File: Select the file that contains the delimited data to import.
Delimited File Start Row: If using the line by line import option, tell the
Import Tool which line to start with by using this option.
Delimited File End Row: If using the line by line import option, tell
the Import Tool which line to end with by using this option.
Escape Single Quotes: Select this option to escape any single quotes
located in the data. Select this option if the data contains single quotes and they
are not escaped.
Escape Character: The escape character to use if escaping single quotes.
Column Options
Populate Column: If using the line by line option, this option
gives the user the ability to select which columns correspond to the data
in the delimited file.
Delimited File Column Number: If using the line by line option,
this option gives the user the ability to tell the Import Tool which column of
the delimited file corresponds to the column of the table.
Wrap in Single Quotes: This option allows the user to specify
whether or not to wrap the column data in single quotes when generating
the SQL to import. If textual data is already wrapped in single quotes,
deselect this option.
The Excel and Fixed Width file import options have the same options that are listed above.
