Re: read data from Excel Spreadsheet to Oracle Database

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 28 May 2003 00:54:59 GMT
Message-ID: <DNTAa.1778$uF4.1681@news01.roc.ny.frontiernet.net>

one more choice:

Use perl: You'll need modules to read excel file which you can insert in oracle via DBI/DBD.

Although, if the data is large in quantity: sql*loader will work the best for you (or even external tables in 9i).

Anurag

"Monty" <mmontreaux_at_hotmail.com> wrote in message news:6284dd3.0305270840.52a8b7cf_at_posting.google.com...
> 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
Received on Tue May 27 2003 - 19:54:59 CDT