I would preferr SQL Loader utility as bulk and complex data can be loaded
through it, There may be some limitations while loading data through excel.
In your case, If you want to load the data through Excel without any
complexity and the data is readily available in Excel then use any of the
utlities that will be available in the market.
Thanks & regards
Atul
-----Original Message-----
From: Ranganath H M
[mailto:oracledba-ezmlmshield-x71644024.[Email address protected]
Sent: Tuesday, July 25, 2006 5:39 PM
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
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.
Oracle LazyDBA home page