RE: Uplodading data from excel file into oracle table

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 11 Jan 2001 08:19:57 -0800
Message-Id: <10738.126403@fatcity.com>

Save it as a csv and load it via SQL*Loader.

-----Original Message-----
From: bipin sahani [mailto:bipinsahani_at_yahoo.co.in] Sent: Wednesday, January 10, 2001 9:40 PM To: Multiple recipients of list ORACLE-L Subject: Uplodading data from excel file into oracle table

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

---

Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?bipin=20sahani?=
  INET: bipinsahani_at_yahoo.co.in

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 - 10:19:57 CST