Roland,
If you are saying that you have 100 columns in the spreadsheet but you only
want to copy 9 columns into a table with 9 fields then you have 2 choices.
Reduce the spreadsheet to only 9 columns (by copying to another worksheet)
and then saving as a CSV file and importing by sqlloader. I
Roland,
At the risk of being the extremo de la broma to the OT lot.
The field names that you have specified in the excel file will need to be
deleted anyway. You will need a control file that loads the data in to a
table that has a hundred (100) fields. You will then need to save the excel
file