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

At best, it sounds like he wants to read the contents of an excel spreadsheet and load into Oracle. The excel spreadsheet will need saving as a .csv and SQL*Loader to load into an Oracle table or UTL_FILE to read its contents line by line.

M

"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:43:07 CDT