I’m importing a memo field from Oracle into Access and I’m getting some really strange results. After importing the field into a table it appears to have only the first character. However, if I expand the field I can see that all of the data is in fact there, but there is a non-printing character between each letter.
The data which in Oracle looks like
ENTRY1
Looks in Access like
E„ÒN„ÒT„ÒR„ÒY„Ò1
Where I can only assume the boxes are non-printing characters.
Has anyone encountered this?
Any suggestions for rectifying it?
Thanks in advance for any help!