Re: read data from Excel Spreadsheet to Oracle Database

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Tue, 27 May 2003 20:42:29 GMT
Message-ID: <3ED3CDB5.6030504@nospam_netscape.net>

Saving the Excel data in csv format and then importing into Oracle via sqlldr is the easiest way. Otherwise, you basically have to write a client program/script to call a COM object to read Excel data, then write out the data via ODBC or OCI into Oracle.

Have a look at this article:

http://asktom.oracle.com/pls/ask/f?p=4950:8:221969205190673830::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:243814703172,

Cheers,
Dave

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
Received on Tue May 27 2003 - 15:42:29 CDT