Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I need some help : Dinesh

Re: I need some help : Dinesh

From: Lars Sjöström <lasse.sjostrom_at_telia.com>
Date: Thu, 11 Nov 1999 19:25:17 GMT
Message-ID: <xKEW3.482$7xk.188104704@newsa.telia.net>


Dinesh Babu skrev i meddelandet <381FFA37.1EA6002A_at_selectica.com>...
>Hi Everybody,
>
>I need some help in pulling the data from MS-Excel to Oracle database. I
am
>having some data in Ecxel sheet. Now i have to pull that data to Oracle
7.3.
>It has around 85 columns in MS-Excel sheet. If anybody know the procedure
of
>pulling the data then please send me the steps as early as possible.
>
>Regards,
>
>Dinesh
>

There is a way using output files, and comma separated values. Save the data with comma separated values, then use SQL*Loader to get them in the Oracle database.

Lars Sjöström Received on Thu Nov 11 1999 - 13:25:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US