Tools - Import Tool
The Import Data Tool allows data of different formats to be imported and inserted into databases, tables, objects and files.
1. Select Tools->Import Data from the Menubar. This will prompt you to
choose a server in which to import data into. Navigate and select your
server and click ok. This will bring up the Import dialog
2. The first tab in the wizard is the General Tab. First, browse and
select the file you want to import. Once the file is selected a sample
of the file will be displayed in the bottom grid. Then select the
encoding and platform your file is formatted in. The sample columns
will be refreshed as you make changes to your options. Select whether
your file is delimited or has fixed width columns. If your file has
fixed width columns, type the widths of your columns separated by commas
(eg: 15,25,35,60 ). While typing the column widths the sample data will
not change, so make sure to click on the Fixed Width radio box to
refresh. You may select whether the first row in the file contains the
column names to help the import tool map to the table. Last, select the
quote identifier for your data values. Make sure the sample data being
displayed is formatted correctly before proceeding, then click next.
3. In the Format Tab, you may now select the database, schema and
table in which you want to import the data into. If you would like to
import into a new table, you may click on the "..." button which will
open a Create Table dialog with the columns defined in the sample file.
You may change the names and datatypes of the columns in the table and
then click ok. At this point you may import into the newly created table.
If the sample file contains the column names of the values, ADS will make an
attempt at matching the column names of the import file to the names of the
columns of the table. You may reorder the column mapping by changing the
Position column value to match the column number in the sample file, or
you may remove the position value to exclude the column from being
imported. Once all columns are mapped click next.
4. In the Options Tab you may begin by selecting whether you want
"(null)" text values to be converted to NULL values. Then you must
select the format of the dates & time. Date and time values will be
formatted in the text file to be imported into date/time columns. If a
date string is to be imported into a VARCHAR column then the format does
not apply. You also have the option to import directly into the
database, or generate an SQL file with INSERT statements to import into
the database. A sample of the files values are provided below for
configuring the date/time formats. When ready, you may click the Next
button to import the data.
5. Once in the Status Tab the import has begun. You may cancel the
import at any time by clicking on the cancel button at the bottom of the
dialog. If any errors or warnings occur, they will be displayed in the
message text window.
Date and time formats are specified by date and time pattern strings. Within date and time pattern strings,
unquoted letters from 'A' to 'Z' and from 'a' to 'z' are interpreted as pattern letters representing
the components of a date or time string. Text can be quoted using single quotes (') to avoid interpretation.
"''" represents a single quote. All other characters are not interpreted; they're simply copied into the
output string during formatting or matched against the input string during parsing.
| Letter
| Date or Time Component
| Presentation
| Examples
|
G
| Era designator
| Text
| AD
|
y
| Year
| Year
| 1996; 96
|
M
| Month in year
| Month
| July; Jul; 07
|
w
| Week in year
| Number
| 27
|
W
| Week in month
| Number
| 2
|
D
| Day in year
| Number
| 189
|
d
| Day in month
| Number
| 10
|
F
| Day of week in month
| Number
| 2
|
E
| Day in week
| Text
| Tuesday; Tue
|
a
| Am/pm marker
| Text
| PM
|
H
| Hour in day (0-23)
| Number
| 0
|
k
| Hour in day (1-24)
| Number
| 24
|
K
| Hour in am/pm (0-11)
| Number
| 0
|
h
| Hour in am/pm (1-12)
| Number
| 12
|
m
| Minute in hour
| Number
| 30
|
s
| Second in minute
| Number
| 55
|
S
| Millisecond
| Number
| 978
|
z
| Time zone
| General time zone
| Pacific Standard Time; PST; GMT-08:00
|
Z
| Time zone
| RFC 822 time zone
| -0800
|
The following examples show how date and time patterns are interpreted in
the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time
in the U.S. Pacific Time time zone.
| Date and Time Pattern
| Result
|
"yyyy.MM.dd G 'at' HH:mm:ss z"
| 2001.07.04 AD at 12:08:56 PDT
|
"EEE, MMM d, ''yy"
| Wed, Jul 4, '01
|
"h:mm a"
| 12:08 PM
|
"hh 'o''clock' a, zzzz"
| 12 o'clock PM, Pacific Daylight Time
|
"K:mm a, z"
| 0:08 PM, PDT
|
"yyyyy.MMMMM.dd GGG hh:mm aaa"
| 02001.July.04 AD 12:08 PM
|
"EEE, d MMM yyyy HH:mm:ss Z"
| Wed, 4 Jul 2001 12:08:56 -0700
|
"yyMMddHHmmssZ"
| 010704120856-0700
| |
|
