RE: Uplodading data from excel file into oracle table

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Thu, 11 Jan 2001 12:02:10 -0500
Message-Id: <10738.126410@fatcity.com>

An even easier way is to save the Excel spreadsheet as a prn (fixed length = flat file) and use sqlload to load it into your table. The only extra = effort is to build the sqlload import control file.

>>> <GKor_at_rdw.nl> 01/11/01 11:28AM >>>
try this

http://www.oraxcel.com/=20

> -----Oorspronkelijk bericht-----
> Van: bipin sahani [SMTP:bipinsahani_at_yahoo.co.in]=20
> Verzonden: 11-jan-01 06:40
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Uplodading data from excel file into oracle table

>=20

> Hi All,
> I want to upload a data into oracle table from excel
> worksheet.In my oracle table there are 60 fields.And
> my execl contains only those fileds which are NOT NULL
> in table.So I've about 16 fields in my excel which is
> having around 5000 rows.What's the best possible and
> simplest way to upload this data in table from this
> EXCEL WORKSHEET.
> Any help regarding this will be greatly appreciated
> Thankx in Advance
> Bipin

>=20
>=20


> ____________________________________________________________

> Do You Yahoo!?
> Get your free @yahoo.co.in address at http://mail.yahoo.co.in=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: =3D?iso-8859-1?q?bipin=3D20sahani?=3D
> INET: bipinsahani_at_yahoo.co.in=20

>=20


> 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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author:=20
  INET: GKor_at_rdw.nl=20

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). Received on Thu Jan 11 2001 - 11:02:10 CST