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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

From: vikram singh <vikramsingh120_at_gmail.com>
Date: Thu, 18 May 2006 04:43:48 +0530
Message-ID: <c81241cd0605171613s26a4b19as63a0e7eec8eba4e8@mail.gmail.com>


Hello All,
  I have successfully loaded data from an excel sheet into my oracle table. Thanks for all your valuable suggestions. You all are doing a great service. Thanks again,
Vikram.

On 5/18/06, Ramji <ramjirrajan_at_gmail.com> wrote:
>
> Best way is to use DTS package. Install sqlserver client. You will get
> an
> option import export data. You can pick data from anywhere and drop it
> anywhere. for oracle it will little slow as it commits each record. It is
> great option to try.
>
>
> Ramji
>
>
>
>
>
> ----- Original Message -----
> From: "Kirtikumar Deshpande" <kedeshpande_at_yahoo.com>
> To: <vikramsingh120_at_gmail.com>; <oracle-l_at_freelists.org>
> Sent: Wednesday, May 17, 2006 11:23 AM
> Subject: Re: how to load data from Excel sheet into Oracle tables using
> SQL*LOADER
>
>
> > Hi Vikram,
> >
> > There is another way.. if you have money and this is an ongoing thing..
> >
> > http://www.oraxcel.com/projects/sqlxl/
> >
> > I came across this product when I was asked a similar question.
> > We don't use this product, however.
> >
> >
> > Regards,
> >
> > - Kirti
> >
> >
> >
> >
> >
> > --- vikram singh <vikramsingh120_at_gmail.com> wrote:
> >
> >> Hi All,
> >> Is there a way to load data from an Excel sheet into an Oracle table
> >> using
> >> SQL*Loader? I know there must be.
> >> Please, can anyone help me out how this can be achieved. Thanks in
> >> advance.
> >>
> >> Vikram.
> >>
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 17 2006 - 18:13:48 CDT

Original text of this message

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