"Oradba Linux" <oradba_linux_at_attbi.com> wrote in message news:<pan.2003.05.27.16.46.31.840522_at_attbi.com>...
> On Tue, 27 May 2003 09:40:44 +0000, Monty wrote:
>
> > Hi, I need to import information from a MS Excel spreadsheet into an
> > Oracle database table. This isn't a one-off implementation but an
> > ongoing thing. The Excel files have the extension .xls (not .csv which
> > would have been trivial).
> >
> > Somewhere I have heard of something called ExcelORD but Google only
> > shows up 2 hits (in Japanese so I can't make anything out), and the
> > Oracle website none.
> >
> > Any pointers?
> >
> > Thank you
> > Monty
> If the excel files could be saved as an .csv file then use sqlldr to load it into a table.
Look for oraexcel. There is third party utility to do this job.
> If using oracle 9i try to use external tables .
Received on Tue May 27 2003 - 18:55:33 CDT
