excelms-accessms-access-2003

MS Access: Need to hit backspace twice to delete one character that was copied over from Excel


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?


Solution

  • Export to CSV. Paste in notepad. Remove hidden character then copy and past in MS Access.