Re: Download Question

From: Arndt Binninger <A.Binninger2_at_deutschepost.de>
Date: 2000/07/26
Message-ID: <397E8D9E.D60EDD3@deutschepost.de>#1/1

Hi,

you can also save the excel sheet as txt file and use a stored procedure (via UTL_FILE-package) to process data or you can use Pro*C.

kskasi_at_hotmail.com wrote:

> 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