how to load excel sheet data into oracle database without using sqlloader??
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
Check out this product. Might be what you are looking for..
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
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
what about an external table?
I'm stmontgo and I approve of this message
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).
Click Here to Expand Forum to Full Width