Re: importing xls spread sheet into a table

From: <karsten_schmidt8891_at_my-deja.com>
Date: Fri, 11 Feb 2000 09:56:23 GMT
Message-ID: <880mc7$tki$1@nnrp1.deja.com>

Hi,
to get the txt file into oracle, you 'd have to use sql*loader. you need to write a control-file that describes the file-format. the online docs for sql*loader provide some examples to start with.

HTH
Karsten

In article <88026c$fbn$1_at_nnrp1.deja.com>, M. Armaghan Saqib <armaghan_at_yahoo.com> wrote:
> You could also use my utility SQL Link for XL to directly insert data
> into
> an Oracle table from XL.
>
> regards,
> M. Armaghan Saqib
> +---------------------------------------------------------------
> | 1. SQL PlusPlus => Add power to SQL Plus command line
> | 2. SQL Link for XL => Integrate Oracle with XL
> | 3. Oracle CBT with sample GL Accounting System
> | Download free: http://www.geocities.com/armaghan/
> +---------------------------------------------------------------
> 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
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 03:56:23 CST