Re: read data from Excel Spreadsheet to Oracle Database

mmontreaux_at_hotmail.com (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).

Well, then just rename the file to have a csv extension.[*]

> 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?

I use perl to do some processing of simple Excel files. I'm fairly happy with it. Spreadsheet::ParseExcel at
http://search.cpan.org/author/KWITKNR/Spreadsheet-ParseExcel-0.2602

Xho

• Joke. But I've had people do this and not understand why it didn't work.

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB