1. Save an Excel document as a comma-separated CSV file. (Note: Please go to the watch line)
2. Generate a control file as follows, Test.ctl:
Load Data Infile 'D: /Test.csv' Append Into Table Table_name Fields Terminated By ',' (Field_Name1, Field_Name2)
3. Row the following import statement in the DOS prompt:
D: / sqlldr userid = test / pwd @ server control = D: /TEST.CTL