Getting Unicode From Excel

nullGumby · December 1st, 2006, 12:45 PM

I'm writing an application in Access 2K3 and I need to load an Excel spreadsheet and read from the cells contained therein.

Everything is working fine, but the Excel spreadsheet contains unicode characters. When in VBA, I read from the cell into a string, the Unicode characters don't come through.

Does anyone know how to get around this? Appreciate the help.

- nullGumby

nullGumby · December 1st, 2006, 07:02 PM

I figured something out--this is what I did.

Code:

strReplacementText = StrConv(objWorksheet.Cells(1, 1), vbUnicode)

To expand: I'm taking a non-Unicode string, and replacing non-Unicode characters for Unicode characters. I didn't think the StrConv() would work, but then I just thought of converting the source to Unicode also.

Reminds me of fraction-math from grade school--you first have to turn the whole numbers into fractions before you can use 'em! ;) Thanks.

- nullGumby