Doug Steele
dbdoug at gmail.com
Sun Apr 5 13:51:12 CDT 2009
Hello All: I have to read a unicode string from a SQL database into Access. The bytes are doubled up; for instance, the string for 'fred' in hex is '6600720065006400'. I found the Access function 'StrConv', which almost does the translation, but leaves a blank after each character: StrConv(myFredString,vbUnicode) = 'f r e d '. I'd prefer not to have to step through every string dropping the spaces. Does anyone know of a more elegant way to do this? Thanks, Doug Steele