Re: Download Question

From: Tom Best <tabest_at_bellatlantic.dontspamme.net>
Date: 2000/07/26
Message-ID: <CDrf5.1869$JI5.54106@typhoon1.ba-dsg.net>#1/1

Kasi:

Another way... you could use an Excel ODBC driver and read directly from the spreadsheet and process it into your Oracle table. This could either be done with an ODBC link deom within Oracle, or you could use Access or something a have an ODBC connection to Oracle and one to Excel.

HTH,
Tom Best

<kskasi_at_hotmail.com> wrote in message news:397E3D0D.79D1655D_at_hotmail.com...
> 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