Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: loading data from an excel sheet
> 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-lReceived on Thu Oct 14 2004 - 11:43:52 CDT
![]() |
![]() |