Re: read data from Excel Spreadsheet to Oracle Database

If you have SQL Server in your shop, then have a look at Data Transformation Services (DTS). With this utility, you can export/import to/from any OLE DB data source. It is quite easy to pull from Excel and push into Oracle. And you can save the routine for automated processing.

I know it introduces SQL Server tools into the equation, but it works nicely.... ;)

Cheers,
Brian

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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam" from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"