Converting .xls to .csv file using pl/sql or any other method ( oracle 9i)
Wanted to know if there is a way for converting excel to .csv.
.xls is a Microsoft proprietary binary format for storing Excel workbooks.
.csv is a flat data file (character seperated values) for a set of data.
The two are not compatible.
We cannot just "read" the binary file format and convert it to .csv. I am aware of this but just wanted to post this question if any changes are there with newer version of oracle.
i have a directory say 'F:\purple_top\'. I will be getting .xls file into this directory. I need to change it to .csv and load into oracle external tables. Any thoughts or advance coding? Help or reply appreciated.