Firstly, export to CSV.
Then ftp your csv files to your server.
Then create control files to represent the data within your csv files.
Then run sql loader using each of your control files.

I've been deliberately vague about how to do this as it would be much more
beneficial to you to read up on sqlldr. Check out the Oracle documentation.
It has everything you need.

Michael Peel


-----Original Message-----
From: shivas
[mailto:oracledba-ezmlmshield-x60056609.[Email address protected]
Sent: 04 April 2008 09:58
To: LazyDBA Discussion
Subject: sqlloder - very urgent

Hi experts,

I have three Excel file (.xls) Each excel file have 7000 records with five
fields name.
I had created table for insert values. pls tel me how can i insert 7000
recored using SQL LODER.
We using sun solaris box OS, we using oracle8i database. pls give me
solution as soon as possible

Thanks in advance.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page