MSAccess VBA - Help on query

Question

MSAccess VBA - Help on query

Anonymous

Dear All,

I have imported the below Excel sheet into an MSAccess table:

As you can see the length of the two value should be 19 but, due to an accidental char (maybe carriage returns), I have 20 in the first row.

This is an issue because when I import the above table in an accdb file I did not find a way to remove this strange char.

From here you can download a copy to check my issue

Thanks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Accepted answer

0 additional answers

Answer 1

You can use a function such as the one found at https://www.devhut.net/unveiling-the-hidden-characters-in-your-strings/ to output the character representation of each string to see, and eliminate hidden characters.

You can use Replace() to eliminate individual characters either via VBA, or better yet, through an UPDATE query.

Share via

MSAccess VBA - Help on query

0 additional answers