Re: loading data from an excel sheet

  • From: Greg Norris <Spikey.McMarbles@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Oct 2004 08:16:38 -0500

Wow... that's quite possibly the most obnoxious email disclaimer I've seen.

On Thu, 14 Oct 2004 11:58:09 +0530, a.kish@xxxxxxx <a.kish@xxxxxxx> 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@xxxxxxx
> 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.
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


-- 
"I'm too sexy for my code." - Awk Sed Fred.
--
//www.freelists.org/webpage/oracle-l

Other related posts: