How to import Excel spreadsheet data into an Oracle database (10g)?
In MS Excel, save the contents of the spreadsheet as a comma delimited file. Choose File->Save As. In the Save As Type pulldown menu, choose CSV (Comma Delimited). Now that you have the data in a vendor-neutral format, you can use SQL*Loader to load the data into an Oracle table. The
Oracle Utilities Guide
contains information on how to use SQL*Loader. Chapter 6 discusses SQL*Loader concepts. At the end of this chapter, the documentation discusses some case studies on loading data. Case Study 3 shows you how to load from a CSV file like the one you created above.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.