Re: Loading a Ascii file

I'm not biased. It is my "boss" that is biased he has to go with this to the client and offcourse he would favor easier tools. But in general I'm very surprised that there are almost no alternatives. And offcourse I managed to make it work.

"Thomas Gaines" <Thomas.Gaines_at_noaa.gov> schreef in bericht news:3D651268.D0A0E9EC_at_noaa.gov...
> Peter -
>
> It would have been nice if you'd mentioned your bias against SQL*Loader
> in your very first note in this thread. The various responders would not
> have wasted their time recommending SQL*Loader.
>
> If you're out to reinvent the world, please proceed. If your goal instead
> is to load the data as quickly and efficiently as possible and get on with
> your "real" work, then you and your boss need to take a closer look at
> the already-existing tools. SQL*Loader is quite flexible, and it can
handle
> comma separated fields from MS Excel with ease. Yes, you may have to
> create a number of SQL*Loader control files to handle the various
> input formats, but what's the alternative? IMO, you'll spend much,
> much, much more time and money developing your own "intuitive"
> interface than using what's already available.
>
> Tom
>
> Peter wrote:
>
> > In general there is nothing wrong with sql*loader, but my boss is not
very
> > excited about this. The reason is that it is difficult to manage an xls
file
> > for example. It would be easier if there would be a direct interface.
And
> > 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
> > you can save a lot of money if you can make a good utility that can do
this
> > in a more intuitive manner.
> > "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 Thu Aug 22 2002 - 19:52:02 CEST