Re: Loading a Ascii file

MsAccess
Oracle Odbc
Link table in MsAccess
Copy data from Excel
[Quoted] 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
> > >
>
Received on Mon Aug 19 2002 - 20:43:49 CEST