One option is saving the excel file in CSV format, and then load it into the database using <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160″>SQL*Loader</a>.
Also, you could use a tool, such as <a href=”http://sourceforge.net/projects/quickload/”>QuickLoad</a>
A third option would be to use ODBC from excel to tie to an Oracle table that has the exact same layout as your oracle spreadsheet. then cut/paste your rows into the excel sheet and let it save the data.
This works as long as your datatypes match up correctly and as long as your data contains all of the same datatype. Excel assumes that the first row it loads defines the datatype for all subsequent rows. Excel then goes on to interpret numbers in each column differently from strings in the same column so thanks to excels dynamic treatment of values may have issues on certain situations. Make sure to check your results after you load.
Good luck, Kevin
SQL loader is the best choice, you can use a direct loading for faster performance.
Cheers – Muthu