Re: Importing a comma delimited file or excel worksheet into Oracle 8i .

From: <karsten_schmidt8891_at_my-deja.com>
Date: Wed, 24 Jan 2001 13:29:48 GMT
Message-ID: <94mlc6$i5$1@nnrp1.deja.com>

sql loader is probably what you are looking for.

it is fairly well documented in 'Oracle Tools' which comes on the regular documentation cd.

Karsten

In article <3a6e7b14_2_at_news2.cwnet.com>, "Edward Ascencio" <cedwarda_at_altavista.com> wrote:
> Hi, Guys
>
> How can I import a comma delimited file say a text I create with
data,
> with two large string fields that would be used for recording memos to
the
> extent medium size paragraphs into all ready created Table that
matches the
> Character types from the columns from the excel worksheet or file.
>
> I know I can write something in C to read from and write to the
database or
> use PL-SQL embedded
> programming to do it. Is there any other methods you guys might know
of.
>
> Import/ Export Utility I have read about but I haven't worked with it
>
> Edward Ascencio
> Client / Server Applications Developer
> Folsom, Ca.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 07:29:48 CST