I've converted several Excel sheets with our product id's that we received from our distributors into Access. The problem is that the naming convention is not formatted exactly like ours. I can change it, but there's just too many entries (about 2500 product id's per worksheet).
For example: Our distributors worksheet has a column that displays our product id# as 15-0011306400. In fact, all of the product id's that they sent to us has a "15" in front of the actual product id. Our product id format is xxx-xxxxx-xx without the "15" in the front, but with hyphens. So it should show 001-13064-00. Like I said, the "15" in the front is not part of our naming convention.
Any help or ideas is greatly appreciated!
For example: Our distributors worksheet has a column that displays our product id# as 15-0011306400. In fact, all of the product id's that they sent to us has a "15" in front of the actual product id. Our product id format is xxx-xxxxx-xx without the "15" in the front, but with hyphens. So it should show 001-13064-00. Like I said, the "15" in the front is not part of our naming convention.
Any help or ideas is greatly appreciated!
![[spin]](/data/assets/smilies/spin.gif "[spin] [spin]")
