If you're a windows user, you can do the following:
(not a nice dba solution but it works ;-))
create a new access db
link the excel sheet to the access file through link external data.
Link your oracle table the same way but use an ODBC link
Create an append query that insert all the records from your excel file in your oracle file.
Like I said, it's a work around if you don't know sql-loader.
Otherwise use sql-loader with a delimited (csv) file.

Hope I could help

Erwin

-----Original Message-----
From: Malavika Gupta [mailto:oracledba-ezmlmshield-x33743903.[Email address protected]
Sent: donderdag 3 maart 2005 11:53
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