Re: Loading a Ascii file

Adam Hetman wrote:

> MsAccess
> Oracle Odbc
> Link table in MsAccess
> Copy data from Excel
> Paste in open table
>
> Hetman
>
> Uzytkownik "Thomas Gaines" <Thomas.Gaines_at_noaa.gov> napisal w wiadomosci
> news:3D6139A0.416ECD8D_at_noaa.gov...
> > Peter -
> >
> > SQL*Loader is part of the standard Oracle installation. You should find
> > it wherever the executable Oracle programs for your OS are stored. Look
> for a
> > file
> > called sqlldr.exe on either your Unix or Win2000 machine.
> >
> > Tom
> >
> > Peter wrote:
> >
> > > Ok , I knew that this exists, but can you download it somewhere? Or is
> it
> > > somewhere in another program?
> > > "Daniel Morgan" <dmorgan_at_exesolutions.com> schreef in bericht
> > > 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".
> > > >
> > > > Daniel Morgan
> > > >
> >

Why choose the most difficult method imaginable short of retyping it all in?

Do you get paid by the hour? ;-)

Daniel Morgan Received on Mon Aug 19 2002 - 21:15:51 CEST