Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: importing xls spread sheet into a table
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 Thu Feb 10 2000 - 20:33:45 CST