Can anybody please help me how to load data from MS EXCEL sheet to tables.
Thanks in advancve.
Printable View
Can anybody please help me how to load data from MS EXCEL sheet to tables.
Thanks in advancve.
There are 2 ways for that, one save the excel sheet as a csv file and then use sqlldr to load the comma delimited file into oracle table.
Else, if you have MS Access, copy the data from XL and paste it onto the table in access.