Hi Tom!!!

Tom, can u please tell me how to import data from .xls file into oracle tables.I have searched a lot but I could not find good information.

this is my code,

create table ext_table (
claim_id varchar2(255),
rdf_file_name varchar2(200),
time_stamp varchar2(200),
asc_number varchar2(200),
woid varchar2(200),
sender_country varchar2(10),
date_received varchar2(200),
date_shipped varchar2(200),
date_purchased varchar2(200),
symptom_code varchar2(200),
fault_code varchar2(200),
product varchar2(200),
product_code varchar2(200),
product_code_name varchar2(200),
pay_to_party_number varchar2(200),
claim_status_name varchar2(200),
payment_proposal_number varchar2(200)
)
organization external (
type oracle_loader
default directory reddy
access parameters (
records delimited by newline
logfile 'ar.log'
badfile 'ar.txt'
fields terminated by ','
missing field values are null
)
location('ar.xls')
)
REJECT LIMIT unlimited;


after executing this I am getting ascii characters in table.


So please tell me with a example if possible.

Thank u,



L.Sudhir Reddy