Re: Excel to oracle

Hi,

take a look at the documentation for Oracle Gateway. If you are on an NT box, the part of Oracle Gateway that gives you access to com sources like Excel is for free and comes with your Oracle Server.
You just have to set it up ;)
But the manual is pretty clear.

Mark Leith schrieb:
>
> Where exactly can I RTFM about this then?
>
> I take it that I can make Oracle "think" that an Excel spreadsheet is a
> table, and do a simple create table excel_table as select...?
>
> Cheers
>
> Mark
>
> -----Original Message-----
> Nissim
> Sent: Friday, March 30, 2001 12:26
> To: Multiple recipients of list ORACLE-L
>
> You are making your life so difficult... :)
> As of Oracle 8.16, Oracle provides you with a free gateway to ODBC
> datasources - you can easily access Excel just as though it was an Oracle
> table. Why bother with all the transfers and all that? If you still need the
> table as a native Oracle table, just move the data as you would between two
> Oracle tables. It works and it is free.
>
> Tzachi
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 30, 2001 8:50 AM
>
> > Ravindra,
> >
> > Besides the conventional way of exporting into a CSV and then use
> SQLLoader,
> > please be informed that there are 2 product which are able to handle your
> > requirement. One is SecondWind and the second is Oraxcel.
> >
> > Regards,
> > Pierre
> >
> > -----Original Message-----
> > From: ravindra [SMTP:ravindra_at_sentica.com]
> > Sent: Thursday, March 29, 2001 8:46 PM
> > To: ORACLE-L
> > Cc: ravindra
> > Subject: Excel to oracle
> >
> > I have a Excel file.How to port the data to Oracle table.
> >
> > I read some artical about using ODBC and things like that.But
> > I am not clear.
> >
> > How can we generate a dat file delimited with comas so that I can
> > use SQlLOADer to port the data.
> >
> > Thanks
> > Ravindra
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ravindra Basavaraja
> > INET: ravindra_at_sentica.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: pierre.olaru_at_citicorp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tzachi Nissim
> INET: tzachi_at_attunity.co.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> ----------------------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted Mails can NOT be checked !
>
> * * *
>
> Diese Mail wurde auf Viren ueberprueft
> Hinweis: Verschluesselte Mails koennen NICHT geprueft werden !
> ----------------------------------------------------------------------

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
AMS-Gebäude: E6 R08
Tel.: 0211/533-4893

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).