Re: Importing TAB separated files into Oracle..

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Wed, 15 Dec 1999 13:30:23 -0800
Message-ID: <8391kb$5mt$1@plo.sierra.com>

LOAD DATA
INFILE 'my_raw_data.txt'
TRUNCATE
INTO TABLE my_temp_table
FIELDS TERMINATED BY TAB
(
FIRSTNAME,
MIDDLENAME,

LASTNAME,
ADDRESS1,
ADDRESS2,

CITY,
STATE,
POSTAL_CODE,
COUNTRY
)

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:38568f10.335869245_at_news.earthlink.net...
> I can't find anything on TAB separated stuff in SQL Loader... is Ms
> Access the thing to go for?
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Wed Dec 15 1999 - 15:30:23 CST