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
-~----------~----~----~----~------~----~------~--~---
