Manual Data-Load made easy from MS Excel to SQL Developer

If you would like to load a sample data into a database the most efficient way possible, here is how:

1. Open your excel source file and first UPPERCASE all column headings by replacing space (“ “) with underscore (“_”) for all columns. Since database columns have to be in uppercase for easy to query, otherwise SQL Developer will put quotation for lowercase column heading names. 

=UPPER(SUBSTITUE(A2," ", "_"))

UPPER - will capitalize the letters

SUBSTITUTE - will replace space (" ") with underscore ("_")

2. Save the excel data as .csv file and import into SQL Developer.

3. Right click into Tables > Import Data... and follow the instructions.

Hope this helped!