Re: Download Question

Hello,

You can use SQL*XL for the purpose of uploading a spreadsheet of information into an Oracle table.

Have a look at it at http://www.oraxcel.com

You can download a free LITE version of the software that allows you to evaluate the process. The LITE version rollsback at the end of your upload though...

Hope this helps,

Gerrit-Jan Linker

In article <CDrf5.1869$JI5.54106_at_typhoon1.ba-dsg.net>,   "Tom Best" <tabest_at_bellatlantic.dontspamme.net> wrote:
> 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
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 29 2000 - 00:00:00 CDT