You could save the excel file as a flat comma delimited file and then use
some sort of driver to read that. 0040 does not read Excel files. If you
are using Excel they already you are system dependent.
Jim
"thierry britschu" <t.britschu_at_delta-energy.ch> wrote in message
news:abt2uq$qrd$1_at_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 - 05:50:20 CDT
