var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Export columns in excel sheet to oracle table
In an excel sheet I have 2 columns named -- RollNumber and Name
Now in my oracle database I have a table called Student which also has 2 columns RollNumber and Name..
This table of mine has 10 records..
Now I want to add 500 more records.
The source of these 500 records is the excel sheet which has data in 2 columns.
Now is there any way to export these 500 records from excel sheet into the oracle table Student.
So if such a thing is possible it would be very kind of you to let me know what steps I must follow to achieve this task...
Thanks a lot
from Excel store as csv dataset and then use sqlldr to load it
Save the Excel spreadsheet as a CSV file (comma-separated values). Then write a SQL Loader control script and use it to load the data from the CSV file.
The control file will look something like this:
INTO TABLE student
FIELDS TERMINATED BY ','