Re: Loading a Ascii file

Well, you could probably spend big $ on a tool, like Data Junction, which after you define the appropriate mappings, will go from anything to anywhere.

Or you could just save the xls as csv, write an appropriate control file, and use sqlldr.
Or if you have lots of free time, code up your own custom loader in your language of choice.

No silver bullets that I'm aware of.

--Peter

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 Wed Aug 21 2002 - 21:48:46 CEST