RE: excel to oracle

From: Anand Arvadia <Anand.Arvadia_at_sunh.com>
Date: Wed, 9 Aug 2000 09:27:22 -0600
Message-Id: <10584.114183@fatcity.com>

Datajunction (http://www.datajunction.com/) is a very nice tool. You can use it for this.

Anand

-----Original Message-----
From: Rajanish Joshi [mailto:dbaoracle2000_at_yahoo.com] Sent: Wednesday, August 09, 2000 5: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
also send the HELP command for other information (like subscribing).

Received on Wed Aug 09 2000 - 10:27:22 CDT