i cant help it dear. On Fri, Jul 31, 2009 at 4:52 PM, Javier Montani <jmont...@gmail.com> wrote:
> Couldn't help it !!! > > 2009/7/31 Rob Wolfe <wolfe....@gmail.com> > > >> Javier, >> OK, now THAT was funny! >> Rob >> >> On Jul 31, 7:41 am, Javier Montani <jmont...@gmail.com> wrote: >> > You could also link both via MSAccess. ;) >> > >> > 2009/7/31 sonty <saurabh.zen...@gmail.com> >> > >> > >> > >> > >> > >> > > You can java apis to read from excel and write into oracle. >> > >> > > -Sonty >> > >> > > On Jul 31, 10:50 am, Kamran Haider <kamranhaid...@gmail.com> wrote: >> > > > Dear Rob, >> > > > Thank.s >> > >> > > > On 7/30/09, rob wolfe <rob.wo...@oraclegeeks.com> wrote: >> > >> > > > > You cannot do this via db link. >> > >> > > > > There are several 3rd party tools that will do what you want(toad, >> > > > > pl/sql developer, I think sql developer from oracle), OWB will do >> what >> > > > > you want, you could write a vba script that would update an oracle >> > > > > database from within the workbook . You could also export the >> > > worksheets >> > > > > to csv files and use them as external tables. >> > >> > > > > None of these solutions is particularly attractive to be honest. >> > >> > > > > You can search this forum to see what other suggestions have been >> made >> > > > > (this is a common question) >> > >> > > > > Rob >> > >> > > > > Kamran Haider wrote: >> > > > > > Link data currently in MS excel but dont want to import through >> sql >> > > > > > loader.Actually my user put entries in MS excell and i want to >> design >> > > > > > some querries for them in Oracle ,they have no idea about oracle >> .So >> > > > > > just copy past my querries and get desired reslults. >> > >> > > > > > I want to know this by db link . >> > >> > > > > > On 7/29/09, *rob wolfe* <rob.wo...@oraclegeeks.com >> > > > > > <mailto:rob.wo...@oraclegeeks.com>> wrote: >> > >> > > > > > Do you mean that you want to query data from an Oracle >> database >> > > > > > and (for >> > > > > > instance) create a pivot table in excel? >> > > > > > or >> > > > > > Do you mean that you want to import data that is currently >> in an >> > > > > Excel >> > > > > > workbook into an oracle database? >> > >> > > > > > Two very different questions with very different answers >> > >> > > > > > Rob >> > >> > > > > > Kamran Haider wrote: >> > > > > > > I am oracle 9i user .I want to link Ms excle work book in >> > > oracle >> > > > > > database. >> > >> > > > > > > Please send me some step by step help .I new user .- Hide >> > > quoted text - >> > >> > > > - Show quoted text -- Hide quoted text - >> > >> > - Show quoted text - >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
