Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!lax2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator2-maxim!propagator3-maxim!news-in.superfeed.net!nsnmpen1-lo.nuria.telefonica-data.net!nsnmpen2-lo.nuria.telefonica-data.net!not-for-mail
From: Anthony Hogan <ahogan-nospam-@iespana.es>
Newsgroups: comp.databases.oracle.misc
Subject: Re: como insertar en una tabla de una base de datos de oracle datos que 
 estan en excel?
Date: Fri, 04 Apr 2003 14:00:16 +0100
Organization: Telefonica Data Espagna
Lines: 28
Message-ID: <3E8D81E0.6F11AD5D@iespana.es>
References: <Wucja.347017$HT6.352057@telenews.teleline.es> <1049451026.774090@news.thyssen.com> <JYcja.347607$HT6.352692@telenews.teleline.es> <1049452265.794235@news.thyssen.com>
NNTP-Posting-Host: 194.224.60.54
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: nsnmpen2-gest.nuria.telefonica-data.net 1049461217 21162 194.224.60.54 (4 Apr 2003 13:00:17 GMT)
X-Complaints-To: usenet@nsnmpen2-gest.nuria.telefonica-data.net
NNTP-Posting-Date: Fri, 4 Apr 2003 13:00:17 +0000 (UTC)
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95805
X-Received-Date: Fri, 04 Apr 2003 06:00:03 MST (news.easynews.com)

Guido Konsolke wrote:
> 
> "sonia" wrote...
> > how is the sentence for SQL*LOADER?
> >
> > Thanks.
> >
> 
> Hi Sonia,
> 
> I'm really sorry, but I can't spend enough time to teach
> you the use of this tool. Please refer to the utilities section
> in the server documentation. Maybe you can find useful
> examples on the net.
> 
> Good luck,
> Guido

Hola Sonia,
Otra opción es pasar los datos a Access. Una vez en Access puede crear
un enlace ODBC con la tabla en ORACLE y realizar una consulta de datos
anexados.
Si hay muchos registros o es algo que va a realizar con frecuencia seria
mejor aprender SQL*LOADER.


Saludos,
Anthony Hogan