how data can be stored in oracle from excel sheet and vice-versa ? .
any one make me clear.
Printable View
how data can be stored in oracle from excel sheet and vice-versa ? .
any one make me clear.
[B]>>how data can be stored in oracle from excel sheet and vice-versa ?[/B]
[B]From Excel to Oracle[/B]
Open the file in excel. Save it as CSV file. You can load csv file into oracle using SQL LOADER.
[B]From Oracle to Excel[/B]
Spool the output to text file then open it in excel.
there are a number of third party tools available for the purpose.