| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Uploading data from excel file into oracle table
For small loads like this, I save the Excel file as a TEXT ONLY file then
use SQL*Loader. I keep the control files around, so the process can be
repeated.
-----Original Message-----
From: bipin sahani [SMTP:bipinsahani_at_yahoo.co.in] Sent: Thursday, January 11, 2001 12:40 AM 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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 09:22:31 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |