Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: importing xls spread sheet into a table

Re: importing xls spread sheet into a table

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Fri, 11 Feb 2000 23:10:25 GMT
Message-ID: <BF0p4.77$d9.1553@news0.telusplanet.net>


You can use a tool like Infomaker to read straight from Excel into Oracle using its pipeline utility.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Darius <Darius_at_WaterfrontAssociates.com> wrote in message news:sa6t898u9gt128_at_corp.supernews.com...
> Maz,
>
> The import utility is used for importing data that has been exported from
> an Oracle Database only. There is another free utility called SQL*Loader
> that comes with Oracle that is used for importing text files.
>
> Regards,
> Darius
>
>
> Darius Phipps
> Waterfront Associates
> an Oracle Premier Partner
>
> phone: 415-928-5164
> Darius_at_WaterfrontAssociates.com
>
>
>
> maz wrote:
> >
> > Hello,
> >
> > I'm a beginner in this newsgroup and the the oracle DB. I am trying to
> > import a xls spread sheet into a table. I know I have to convert the
> > file into text format and then import it. but the import utility cannot
> > read the txt file. :(
> >
> > can someone please describe the procedure for importing? I need this
> > very fast. any help is greatly appreciated.
> >
> > Thanx,
> >
> > --
> > ---------------------Use e-mail. It saves trees----------------------
> > Maz Mohammadi Senior Member of the Technical Staff
> > mailto:maz_at_tdiinc.com (408)330-3421
> > http://www.tdiinc.com TDI(Technology Deployment International)
> >
> > "Programming today is a race between software engineers striving to
> > build bigger and better idiot-proof programs, and the Universe trying
> > to produce bigger and better idiots. So far, the Universe is winning."
> > -- Rich Cook
> >
> >
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Fri Feb 11 2000 - 17:10:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US