How to import excel file into Oracle Db

:::::::::::::::::::::::::::

Righ click(table name in schema browser) -> import EXCEl -> select data -> execute wizard->browse excel
->select row to from -> click auto map

(put data in separate excel dont use more sheets in one)

udayangar@stat.kln.ac.lk