You could save the file in Excel as a .CSV file. Then use Oracle SQL Loader utility to import it into Oracle.
Another way could be to use MS Access as the exporter from Excel and Importer to Oracle. Link the Excel table into Access. Use ODBC to link the Oracle table. Then make an append query to append the Excel data into the Oracle table.
In Oracle, the table must be created and have a primary key.
Last Wiki Answer Submitted: October 10, 2005 9:12 am by Randym1,740 pts.