Re: Loading a Ascii file
Date: Wed, 21 Aug 2002 02:06:59 GMT
Message-ID: <7BC89.349520$XH.7795454_at_twister.tampabay.rr.com>
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D612AA0.B456E2E5_at_exesolutions.com...
> Peter wrote:
>
> > Hay, I'm having a small problem. I have an Asciifile with only text and
> > columns are 'seperated' by distance. In this case I have some columns
that
> > are attached for a few records. So I started with placing the columns
> > manually in Excell. Is there a simple way to load an csv or even xls
file in
> > an oracle database. I have sqlplus and toad available, what is not much.
> > Does anyone have a fast way to load this?
>
> SQL*Loader
>
> For information on this tool go to http://tahiti.oracle.com and search for
"SQL
> Loader".
SQL*Loader will work, but my preference is utl_file in PL/SQL. I haven't
touched SQL*Loader since utl_file was added to the tool box. It's the
difference between using a steak knife and a scalpel.
Received on Wed Aug 21 2002 - 04:06:59 CEST