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

Home -> Community -> Usenet -> c.d.o.server -> Download Question

Download Question

From: <kskasi_at_hotmail.com>
Date: 2000/07/26
Message-ID: <397E3D0D.79D1655D@hotmail.com>#1/1

Hello everyone

We receive an excel file via email every week from one of our vendors. The data we receive has to be loaded into our database. My idea was to save that excel sheet as a csv file and load that into a temporary table using SQL Loader then process it and load it into the actual table. The excel sheet has some header as well. I guess that'll get rejected automatically while loading using SQL Loader. Is there a better way of doing the above process.

Thanks in advance

cheers...Kasi Received on Wed Jul 26 2000 - 00:00:00 CDT

Original text of this message

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