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. - Chirag 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 > -- //www.freelists.org/webpage/oracle-l