How to Import Excel Data from Client Machine and save it into Oracle Table?
Dear Gurus,I'm facing an issue , as i want to make a form on EBS R12 ... the form containing a BROWSE button , in which it will allow users to select an Excel sheet from their machine ( Client Side) , then the form has to take the data from that Excel and post it into a customized oracle table for future processing..
I've some approaches in mind .. the Browse Button i believe it will be in a mean of WEBUTIL , the question is how to setup the webutil on the server ( Solaris SPARC ).
assuming that the webutil worked .... we will save the XLS file as a BLOB ... so how to read the data contained in that BLOB ....
4