Hello,
I have a large amount of data I am importing into Access. Im importing two separate spreadsheets and using an inner join query to find matches. However, on one of the imports to Access the data is ridden with letters on the left and right side of the numbers and it is throwing off my inner join match query. Below is an example of what is being imported.
105273R = 6 digits + Letter
105281RR = 6 digits + 2 Letters
119251A = 6 digits + Letter
95226BR = 5 digits + 2 Letters
97619R = 5 digits + 1 Letter
As you can see, some of the numbers are 5 digits or 6 digits long, but they have letters at the end. I'm looking for either a query expression, or probably an update query to remove the letters regardless if the number is 5 or 6 digits long -- I simply want to remove the letter(s). I want this to be done in Access, and not in Excel, prior to the import.
Can you anybody help me with removing these letters from the numbers that have been imported into a table in Access? Thank so much.