RE: Uplodading data from excel file into oracle table

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 11 Jan 2001 18:39:38 -0000
Message-Id: <10738.126417@fatcity.com>

Save the Excel spreadsheet as a .csv (comma seperated value) file, and import that file with SQL Loader.

Regards

Mark

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of bipin sahani
Sent: Thursday, January 11, 2001 05:40
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 - 12:39:38 CST