Gurus

I have a requirement where I need to
put data from an excel sheet to an Oracle table.

Please give suggestions on how this can
be achieved ?

thanks in advance

Answer 1:

If this is a one time thing, use sqlloader.  Use the Excel SaveAs and select
some delimited form such as tab or comma.  Then check your Oracle Utility
documentation to write the control file.

If this is an ongoing process, use something like VB to write a little
import utility using ODBC.

Daniel
Austin, TX

Answer 2:

Create a macro in VBA, which put excel data into array,
 use Oracle Objects for OLE to make a connection to Oracle database
and create a dynaset, then put the data from array to dynaset.

Answer 3:

Use VBA and ADO to cycle through the rows and insert the records.
Very easy to do.