how to load excel sheet data into oracle database without using sqlloader??

[ngwh]

hi guys,

I am aware that we can load table-data from oracle database into MS Excel sheet thru data source but is there a way to do the "reverse" to insert data from Excel sheet into Oracle db thru Excel w/o using SQLLOADER ??

thanks for any advice in advance

[SANJAY_G]

Check out this product. Might be what you are looking for..

http://www.oraxcel.com/

[ngwh]

hi sanjay,

thanks for the recommendation...i hv d/l the oraxcel trial and found that it's not really "easy" to use compare to TOAD's import data function ..for a newby user like me TOAD's import seems to be more user-friendly

[stmontgo]

what about an external table?

[JMac]

Yup, external table is what I was going to suggest.
Dump the .xls into a comma delimited file (or whatever) and create an external table from it.

Then you can refer to it as an ordinary table and insert/update/append etc. into your database table(s).