Old fashion way, works on multiple versions of Oracle.

Save your Excel file as comma separated values file (*.CSV).

Create table in Oracle with your Oracle table column names same as your
spreadsheet.

Use Oracle SQLLoader function to load the data from the CSV file into
the Oracle table.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!