Hi Daiesh, Thanks for ur reply.
Regards, Venkat On Thu, Apr 16, 2009 at 6:09 PM, Daiesh <mcavenkad...@gmail.com> wrote: > > Hi Venkat, > > Finally i used Java XL components to read row by row from XL and > insert as a query only. > I have not use pl/sql. > > Thanks > Daiesh > > On Apr 16, 2:23 pm, R venkat <byven...@gmail.com> wrote: > > Hi Daiesh, > > > > can u give the solution? bcoz it will be helpful to all. > > > > Regards, > > Venkat > > > > On Thu, Apr 16, 2009 at 12:38 PM, Daiesh <mcavenkad...@gmail.com> > wrote: > > > > > Hi All, > > > > > Thanks for all your responses. > > > > > Thanks > > > Daiesh > > > > > On Apr 16, 1:55 am, "Rob Wolfe" <rob.wo...@oraclegeeks.com> wrote: > > > > Wed, April 15, 2009 15:38, Javier Montani wrote: > > > > > > > This info may help: > > > > > > http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10796/a. > > > .. > > > > > > > 2009/4/15 ddf <orat...@msn.com> > > > > > > >> On Apr 15, 9:42 am, Daiesh <mcavenkad...@gmail.com> wrote: > > > > >> > Hi All, > > > > > > >> > How do read MsExcel sheet data from oracle PL/SQL? > > > > > > >> > Advance wishes > > > > > > >> > Thanks > > > > >> > Daiesh. > > > > > > >> I'm curious why you 'need' this. > > > > > > >> David Fitzjarrell > > > > > > not to rain on anyone's parade but all that would do is to stick the > > > > entire contents of the excel file into one BLOB/CLOB field. > > > > > > Somehow i don't get the feeling that is what is being looked for > here. > > > > > > It is certainly possible to write a bit of VBA to insert into a > specific > > > > oracle table (although I do not especially suggest it because it is > icky > > > > and slow). > > > > > > I would instead suggest writing the excel worksheet(s) out to a CSV > file > > > > and use SQL*Loader (or your other favorite toy) to load them or just > > > > define them as an external table(s). > > > > > > These both assume that you want to do it in a somewhat automated > fashion. > > > > If that isn't an issue I know for sure that PL/SQL Developer (from > > > > AllRound Automations -- no i don't work for them) will allow you to > > > inport > > > > from any ODBC source (of which Excel is one). Not especially speedy > but > > > it > > > > does work. I am sure that Toad and half a dozen other tools have > similar > > > > Abilities. > > > > > > As to why someone would want to do something so horrible... I have > > > > several small (10K lines or less) tables that are sporadically > updated by > > > > business users and it is frankly not worth my time to automate the > > > process > > > > and it isnt worth the fight to try to get them to put it into a > format > > > > that is easier for me to deal with. > > > > > > Rob > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---