oracle to and from execl sheet

[govindaraj123]

how data can be stored in oracle from excel sheet and vice-versa ? .

any one make me clear.

[krishnaindia2007]

>>how data can be stored in oracle from excel sheet and vice-versa ?

From Excel to Oracle

Open the file in excel. Save it as CSV file. You can load csv file into oracle using SQL LOADER.

From Oracle to Excel
Spool the output to text file then open it in excel.

[debasisdas]

there are a number of third party tools available for the purpose.