When I copy text from Excel to MS Access text box, the characters copy over, but when I hit backspace it deletes half the character so essentially I have to hit backspace twice to delete on character.
How do I fix this issue?
Export to CSV. Paste in notepad. Remove hidden character then copy and past in MS Access.