PL/SQL program to read data from *.xls file into oracle tables
Posted on 2004-11-15
I have a report data in the form of an " *.xls " file. The data in this file is of different languages
( eg: english, japanese, taiwanese and chinese).
I wrote a ctrl file in PL/SQL to load the data from *.csv file into oracle tables and used 'sqlldr' to get my job done
But Microsoft Excel is troubling us because
When I do save-As the *.xls file into *.csv (comma seperated value format)
then all the character wrt japanese, taiwanese and chinese etc are lost and they are replaced with junk character like "????".
can U please suggest me
a) As how to modify my ctrl file
b) write a new PL/SQL program,
so that it can read the data directly from " *.xls " file into oracle tables without any data corruption ?
( i.e. It should preserve the characters of different languages when exporting data from *.xls file into oracle tables).