Re: Uplodading data from excel file into oracle table

From: <MTPConsulting_at_aol.com>
Date: Thu, 11 Jan 2001 13:05:03 EST
Message-Id: <10738.126413@fatcity.com>

You can save the spreadsheet as a comma-separated values files (.CSV) and then use SQL loader with this file as input and insert rows into a table.

Marc Perkowitz
MTP Systems Consulting

In a message dated 1/10/2001 11:48:52 PM Central Standard Time, bipinsahani_at_yahoo.co.in writes:

<< 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 Received on Thu Jan 11 2001 - 12:05:03 CST