Re: read data from Excel Spreadsheet to Oracle Database

From: Ryan <rgaffuri_at_cox.net>
Date: Wed, 28 May 2003 02:20:12 GMT
Message-ID: <w1VAa.115252$823.70127@news1.east.cox.net>

"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

its easiest to convert your .xls files to a .csv file. you can do this with excel. then just use sqlloader or an external table and a merge. you dont need to write any code.

or do anything fancy. Received on Tue May 27 2003 - 21:20:12 CDT