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: how to load data from Excel sheet into Oracle tables using SQL*LOADER

Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 17 May 2006 09:41:53 -0700
Message-ID: <1147884113.446b52514677a@webmail.hosting.telus.net>


Quoting rjamya <rjamya_at_gmail.com>:

> I have been through this .... optionally enclosed doesn't work
> correctly when you have a " as part of a column value.
>

Yes, if your fields contain special characters there can be some postprocessing required before handing it to sql loader. The same is true if your fields contain e.g. newline "characters" and there are probably a few more pitfalls.

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 17 2006 - 11:41:53 CDT

Original text of this message

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