Re: importing xls spread sheet into a table

save your spreadsheet as comma deliminated file(CSV). Create a control file and specify comma as delimitor then use sqloader to load into target table.

HTH John Chiu

maz <maz_at_tdiinc.com> wrote in message news:38A30B3B.409ABC96_at_tdiinc.com...
> 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
>
>
Received on Fri Feb 11 2000 - 05:11:45 CST