Re: loading data from an excel sheet

How are loading data from excel?
Do you use csv file ?
Do you do it by program or sql loader?
What Oracle version?

Yechiel Adar
Mehish
----- Original Message -----
From: <a.kish_at_tcs.com>
To: <oracle-l_at_freelists.org>
Sent: Thursday, October 14, 2004 8:28 AM Subject: loading data from an excel sheet

> Hellow All,
>
> I want to load data from an excel sheet to oracle databse. I am
> generating insert statemnets and loading the data into a temp table.
>
> The problem i am facing is that, the data is having characters like &, '
> which are causing problmes in loading the data. These charcters are
> also needs to be loaded.
>
> Plz give me some advise how to load complete data from an execel sheet.
>
> Thanks in advance.
>
> Achanta Durga Kishore
> Tata Consultancy Services Limited
> Mailto: a.kish_at_tcs.com
> Website: http://www.tcs.com
>
> DISCLAIMER: The information contained in this message is intended only and
solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services Limited. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services limited on any subject matter.
> Any action taken or omitted to be taken based on this message is entirely
at your risk and neither the originator of this message nor Tata Consultancy Services Limited takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services limited shall be understood as neither given nor endorsed by Tata Consultancy Services Limited or any affiliate of Tata Consultancy Services Limited. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail.
> Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l