Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I need Help about OO4O, samples how to read Excel Files

Re: I need Help about OO4O, samples how to read Excel Files

From: thierry britschu <t.britschu_at_delta-energy.ch>
Date: Wed, 15 May 2002 09:32:40 +0200
Message-ID: <abt2uq$qrd$1@rex.ip-plus.net>


Thanks for your Antswer

What I will like to do !! It's easy.

I will like to have a possibility to read an Excel file from SQL*PLUS,

read cell's and record them in a Oracle table.

I thought that it was possible to read an Excel 5.0 file by using Java ,

but I didn't find anything for the moment.

I had heard that it was possible to carry out that by using OO4O,

without using VBA because I will like to be system independent.

best of regards

Thierry Britschu

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ce11393$0$237$ed9e5944_at_reading.news.pipex.net...
> I think you have misunderstood oo4o, this allows you to access oracle from
> within a COM appl (such as excel). not the other way around.
>
> what is it you actually need to do?
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "thierry britschu" <t.britschu_at_delta-energy.ch> wrote in message
> news:abr32i$ht2$1_at_rex.ip-plus.net...
> > I need samples how to access and read Excel Files. We have ORA 8.1.7
> >
> > and install Oracle Objects for OLE Release 9.0.1 .
> >
> > Can you give me some samples, how to read Excel 5.0 or Excel 7.0
> spreadsheet
> > 's or cell's with
> >
> > OO4O. I will write a SQL Procedure to access on Excel Files from
SQL*PLUS.
> >
> > thanks for anticipation
> >
> > best of regards
> >
> > Thierry Britschu
> >
> >
> >
>
>
Received on Wed May 15 2002 - 02:32:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US