import excel data in oracle database without using sql loader
803648Jul 7 2011 — edited Jul 7 2011HI,
Can some one help me
My scenario is like this . on my local machine (where oracle client installed and oracle server is on another machine. Some excel files are there on my local machine I want to load that data in my oracle database don’t want to use sql loader and I don’t want to convert my excel file in some other format like csv,txt etc ,To achieve this I want to write a plsql code.
I was tried using external table but that work only on server machine but my file format is csv there.
Can I user external table and while passing location as (sapmle.xls)---but it won’t work
My question is that we can’t import excel file directly in oracle database or is any other way we can do that.