Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: loading data from an excel sheet

Re: loading data from an excel sheet

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 14 Oct 2004 17:48:20 +0100
Message-ID: <bf4638041014094860aa1026@mail.gmail.com>


> How are loading data from excel?
> Do you use csv file ?
> Do you do it by program or sql loader?
> What Oracle version?

I dont' know how every one else does it, but I load Excel data via Perl and Spreadsheet::ParseExcel.

A little more time up front, but saves enormous amounts of time on repetitive tasks.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 14 2004 - 11:43:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US