Consider creating an external table if this is a recurrent load.

-----Original Message-----
From: Ranganath H M
[mailto:oracledba-ezmlmshield-x71644024.[Email address protected]
Sent: Tuesday, July 25, 2006 8:09 AM
To: LazyDBA Discussion
Subject: Re: transport data from excel to oracle.

Yes ,
Converting it .csv and loading by SQL loader is the simpler and faster
way.

-Ranga



Atul Jamdade wrote:

>Hi!
>
>Either convert the excel data into CSV fomrat and then load into oracle
>through Sql loader or you can use any other loader utility that will
>directly load data from excel to the oracle tables (Oraexcel is one of
>them).
>
>Thanks & regards
>Atul
>
>-----Original Message-----
>From: Sharma B.M.- Basis - EITL (HAZ)
>[mailto:oracledba-ezmlmshield-x65393527.[Email address protected]
>Sent: Tuesday, July 25, 2006 4:38 PM
>To: LazyDBA Discussion
>Subject: transport data from excel to oracle.
>
>
>How can I transport/export the data from excel to oracle.
>
>
>
>Regards
>
>
>
>DISCLAIMER:
>This e-Mail may contain proprietary and confidential information and is
sent
>for the intended recipient(s) only. If, by an addressing or
transmission
>error, this mail has been misdirected to you, you are requested to
delete
>this mail immediately. You are also hereby notified that any use, any
form
>of reproduction, dissemination, copying, disclosure, modification,
>distribution and/or publication of this e-mail message, contents or its
>attachment(s) other than by its intended recipient(s) is strictly
>prohibited. Any opinions expressed in this email are those of the
individual
>and not necessarily of the organization. Before opening attachment(s),
>please scan for viruses.
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>Make your callers hear anything you like.Call 456 say DIALER TONES.
>
>An idea can change your life.
>
>************** LEGAL DISCLAIMER ************
>This E-Mail may contain Confidential and/or legally privileged
Information and is meant for the intended recipient(s) only. If you have
received this e-mail in error and are not the intended recipient/s,
kindly notify us at [Email address protected] and then delete this
e-mail immediately from your system. You are also hereby notified that
any use, any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this e-mail, its
contents or its attachment/s other than by its intended recipient/s is
strictly prohibited and may be unlawful.
>
>Internet Communications cannot be guaranteed to be secure or error-free
as information could be delayed, intercepted, corrupted, lost, or
contain viruses. IDEA Cellular Limited does not accept any liability for
any errors, omissions, viruses or computer problems experienced by any
recipient as a result of this e-mail.
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>
>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page