unicdie support

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

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