Re: Regarding Loading of excel data file into oracle database
Date: 1998/06/12
Message-ID: <897668894.924031_at_mn8>#1/1
Using an Excel ODBC driver and a tool like SQLMover you can load directly
from (and reload directly to) an Excel DB. Both the MS ODBC desktop driver
pack and SQLMover can be downloaded from http://www.sqlmover.com. To make a
database in an Excel Worksheet you have to mark the cells involved and go to
the name box and give it a name.
Peder Holst
Praba Dorai wrote in message <357BFA04.8FEEBE5B_at_pluto1.engr.sgi.com>...
>I tried to put the excel data file using SQL*LOADER(each field having
>more than one space within the field ,fields are delimitted by tab and
>there is no fixed lentgh for each filed). I was unable to succeed.
>
>Can anyone tell me what kind of option I have to try to
>load the excel data file into the database ?
>
>
>Thanks in advance.
>
>
>Praba
Received on Fri Jun 12 1998 - 00:00:00 CEST