Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> excel to oracle
Dear Listers ,
I have lot of data in excel and want to store this
data in the oracle database.
I need help in following.
1)can I insert data directly in to database or do I
have to use sql*loader for it,if sql*loader then how I
go about it.
What I have done is saved test.csv file as a ctl file
and tried to use sqlloader but alas it failed ,if any
body tell me the procedure to load .csv file into
oracle schema scott it will be very much helpfull to
me.
Regards,
Rajanish Joshi
Pune India