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: loading data from an excel sheet

Re: loading data from an excel sheet

From: Chirag DBA <ChiragDBA_at_gmail.com>
Date: Thu, 14 Oct 2004 12:12:42 +0530
Message-ID: <1be1d20041013234225e89678@mail.gmail.com>


First thing,

If u r inserting data in Oracle from excel I suggest to use through ACCESS.

This is the nice way without any labour work. So try that .

Let me know if u face any difficulty in that.

On Thu, 14 Oct 2004 11:58:09 +0530, a.kish_at_tcs.com <a.kish_at_tcs.com> wrote:
> 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
Received on Thu Oct 14 2004 - 01:38:13 CDT

Original text of this message

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