Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: read data from Excel Spreadsheet to Oracle Database
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.
If using oracle 9i try to use external tables .
Received on Tue May 27 2003 - 11:45:57 CDT