Hi Malavika

Create a delimiter separated file from Excel,Save as option gives that and then use sql*loader utility of Oracle to insert into the table
Cheers
Abhijit
-----Original Message-----
From: Malavika Gupta
[mailto:oracledba-ezmlmshield-x33743903.[Email address protected]
Sent: Thursday, March 03, 2005 4:23 PM
To: LazyDBA Discussion
Subject: Transfer Data


Hello All,

I have my records in an Excel spreadsheet. Now I have created a table in
oracle database. Is it possible to insert all these datas at one time into
this table instead of writing "Insert" command for each record.

Thanks,
Malavika


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page