Re: Loading a Ascii file

[Quoted] [Quoted] In general there is nothing wrong with sql*loader, but my boss is not very [Quoted] [Quoted] excited about this. The reason is that it is difficult to manage an xls file [Quoted] for example. It would be easier if there would be a direct interface. And [Quoted] also sql*loader is not very handy when the databases of origin differ to much (for example to import old data in a new remodeled database). I think [Quoted] you can save a lot of money if you can make a good utility that can do this in a more intuitive manner.
[Quoted] "Thomas Gaines" <Thomas.Gaines_at_noaa.gov> schreef in bericht news:3D62C9DF.2EF01635_at_noaa.gov...
> Whoa. Did you actually read the replies or what? In unison, we
> answered "SQL*Loader". What's wrong with that fine Oracle utility?
>
> Tom
>
> Peter wrote:
>
> > First I want to thank you all for answering. Are there any programs that
> > facilitate the uploading of datafiles???
> >
> > "Peter" <depend3_at_yahoo.com> schreef in bericht
> > news:lw989.73546$8o4.9886_at_afrodite.telenet-ops.be...
> > > 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?
> > >
> > >
>
>
>
Received on Wed Aug 21 2002 - 20:03:42 CEST