Xref: alice comp.databases.oracle.misc:25532
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newshub.nntp.mr.net!news.mr.net!rain.mm.com!156.98.4.11
From: johng@nospam.mm.com (TurkBear)
Newsgroups: comp.databases.oracle.misc
Subject: Re: importing csv file
Date: Thu, 28 Jan 1999 21:38:37 GMT
Organization: MRNet
Lines: 37
Message-ID: <36b0d77e.24842711@news2.mm.com>
References: <78qfjd$q2v$1@nnrp1.dejanews.com>
Reply-To: johng@nospam.mm.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.mr.net 917537974 10245 204.73.34.8 (28 Jan 1999 15:39:34 GMT)
X-Complaints-To: abuse@mr.net
NNTP-Posting-Date: 28 Jan 1999 15:39:34 GMT
X-Newsreader: Forte Agent 1.0/32.390
X-Authenticated-User: johng


SqlLoader can handle CSV files....See the examples  in the rdbmsxx\loader dir or
here is one I use:

-----------------------------------------------
LOAD DATA
INFILE "ACTIONCD.CSV"
INSERT
INTO TABLE ACTION_CODES
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
   (ACTION_CD,
    ACTION_DESC,
    ACTION_REAS_CD,
    ACTION_REAS_DESC)
---------------------------------------------------------------------------
( Ther table must exist, and the field names must match )

The 'Fields terminated by....' line is the key to the process
Hope it helps,
John Greco




mentholworld@yahoo.com wrote:

>hi
>
>could somebody tell me, how i can import a csv file
>into oracle tables.
>
>anil@excite.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

To reply please remove the 'nospam' part of the address