RE: excel to oracle

From: Kumar, Dharminder <Dharminder.Kumar_at_bmonesbittburns.com>
Date: Wed, 20 Sep 2000 13:02:45 -0400
Message-Id: <10625.117468@fatcity.com>

Rajnish,
This is simple. Let me explain to with the help of an example. First of all you should save the execel data as .csv file. Now this is your data file and not control file. Now depending on your data you need to define your .ctl file and finaly when you have the control file issue the sqlloader command to load the data. Note before you run the sqlloader, you should have the table defined in the database to which you want to load the data. Here is an example. This example is loading data into data table having 5 columns and data filename is data.csv.

• content of control file --- data.ctl

LOAD DATA
INFILE 'data.csv'
INTO TABLE data
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (
name char,
account char,
code char,
delyn char,
extra char
)

The sqlloader command is
sqlldr userid=dkumar/dkumar control=loadxxx log=loadxxx.log direct=true

• sample data from data.csv file COMPAGNIE DU TRUST N,90009874,XXX,n,6 COMPAGNIE DU TRUST N,90009875,XXX,n,5 RESV:PACIFIC CORPORA,90009880,XXX,n,4 ROYAL TRUST CORPORAT,90009882,XXX,n,3 ROYAL TRUST CORPORAT,90009883,XXX,n,3 NORTHERN TELECOM LTD,90009886,XXX,n,3 RESV:GUARDIAN ESTATE,90009890,XXX,n,1 RESV:YORKSHIRE TRUST,90009898,XXX,n,1 RESV:YORKSHIRE TRUST,90009899,XXX,n,1

Hope this helps.

-----Original Message-----
From: Rajanish Joshi [mailto:dbaoracle2000_at_yahoo.com] Sent: Wednesday, August 09, 2000 7:14 AM To: Multiple recipients of list ORACLE-L Subject: excel to oracle

Dear Listers ,
I have lot of data in excel and want to store this data in the oracle database.
I need help in following.
1)can I insert data directly in to database or do I have to use sql*loader for it,if sql*loader then how I go about it.
What I have done is saved test.csv file as a ctl file and tried to use sqlloader but alas it failed ,if any body tell me the procedure to load .csv file into oracle schema scott it will be very much helpfull to me.
Regards,
Rajanish Joshi
Pune India

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
--

Author: Rajanish Joshi
  INET: dbaoracle2000_at_yahoo.com

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 Received on Wed Sep 20 2000 - 12:02:45 CDT