Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Download Question
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