There exist one more way.

I'm using utility (set of macros) SQL*XL (www.oraxcel.com). It makes
operations like that extremely easy. I select option insert, select table
name na column names and just select data cells.

KAzi

LAUWERYSEN Erwin wrote:

>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
>
>
>--------
>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