Reading Spanish Characters

[priyaahh]

Hi Friends,

I am reading cells from excel vba and storing in oracle database.
I have a problem here: there are some special characters as well as spanish characters in some of the cells in excel. This is not reading properly and storing properly (means storing the same as it is given in excel cell) in the database.

For Eg: string like : mph-434ĆEĘ needs to be read and stored using Vba.

Kindly help how to read spanish characters from excel using vba and store in db.

Thanks in Advance,

Regards,

[DaveAuld]

Don't place the question in Code Blocks.........Code Blocks are for, you guessed it, code!

Dave Find Me On: Web|Facebook|Twitter|LinkedIn CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.