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@xxxxxxxxx>
To: <vikramsingh120@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
