> 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 -- //www.freelists.org/webpage/oracle-l