I have written a small application that is linked to Excel files, reads two spreadsheets and does some comparisons.
Those sheets contain SS numbers.
Now I see that some socials are aligned to the right side and some to the left side.
And the problem is that Access only reads the first set of socials, the rest are showing as error.
Since user gets those files from a third party software, no way to figure out why they're like this..
How can I overcome this issue?