unicdie support

[madhavi_m]

Hai,
I have a problem like this:
I have data in excel sheets. It contains some 6 columns and around 4000 rows. I wrote code in VB to
extract the data from excel to oracle database.Here I read each cell by cell and writes the same in
the database.My excel data may be in different european languages.It contains some special chars like degree centigrade,╚,°,Ä
and also some greek chars.For greek chars when i read the data of excel cell it is giving
error,when i debug it and view the cells data it is giving '????' marks instead of actual data, how
to do this

[Cimperiali]

How did you insert greek chars in excell? By changing FontName? Pasting symbols? Drawing pictures?...? May be you simply need, reading cells values, to retrieve the values in a variant and to have a look at the value of char. Or you may do an explicit typecast (valueretrieved= cstr(yourcellvalue))
ie:
debugvalue_to_show = chr$(vntValue)


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater