Re: excel to oracle

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 5 Oct 2007 18:17:15 -0800
Message-ID: <4706e21b$1@news.victoria.tc.ca>

Tim B (nospam_at_someisp.ca) wrote:
: I have some data in an Excel spreadsheet - about 100 -200 records - that I
: need to import into Oracle, likely with some transformation required. I can
: convert it to csv or xml via MS Access and then set it up as an external
: table and proceed from there. What other ways could you suggest that might
: be feasible for this task? Is there another way to do it with xml as the
: source?

Excel can directly access Oracle queries, but I haven't used it recently enough to say if this would help or how to do it.

Perl can use module Spreadsheet-ParseExcel (from CPAN) to input excel, and then DBI DBD-Oracle to write to Oracle. Received on Fri Oct 05 2007 - 21:17:15 CDT