RE: excel to oracle

Check out http://www.oraxcel.com/projects/sqlxl/index.htm There are probably some free downloads to move excel to Oracle hopefully others will reply.

What are the errors you are getting using sql*loader? That should be very straight forward.

Rick

> -----Original Message-----
> From: Rajanish Joshi [SMTP: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
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 09 2000 - 06:10:21 CDT