Avatar of Marv1n
Marv1nFlag for Afghanistan asked on

Urgent Assistance Needed - Excel/Access Address Verification

Experts,

I need a hand in figuring out a quick way to process 30k+ rows of Excel or Access data that has street addresses, but no zip codes.  I have several zip code tables I found online, but they do not help as in some cases the area the addresses are in have multiple zip codes.

Can anyone help?

Many thanks!!!
Microsoft ApplicationsMicrosoft ExcelMicrosoft Access

Avatar of undefined
Last Comment
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

8/22/2022 - Mon
Jeffrey Coachman

It will be near impossible to correctly match Zip codes from the address' alone.
Sure the State helps, but it will never be 100%

(Try matching "100 Main Street" in Google Maps and see how many matches you get...)
;-)

Even if it did match some, many will be incorrect matches, ...which would be worse than no match at all.

Spelling errors and missing values will compound this problem even more...

Perhaps I am missing something because I cannot see your data, ..so lets see what other experts post.

;-)

JeffCoachman
ASKER
Marv1n

I have data like this:
3706 N. SUGAR RD            PHARR      TX

In different columns, and need to look up the correct zips and add to the data.

Willing to pay, but the tools that I've seen via The Google do not have reviews or anything that would lead me to believe they will address my problem.

Thanks!!
ASKER CERTIFIED SOLUTION
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

Marv1n,

OK, ...then it will be a bit easier with that info, ..from your post I presumed that you only had the street address...

You can continue on with TheHiTechCoach
;-)

JeffCoachman
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
Marv1n

Completed using the CASS API ;)
ASKER
Marv1n

I've requested that this question be closed as follows:

Accepted answer: 0 points for Marv1n's comment #a39582990

for the following reason:

because it worked
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

To make the question complete would you please sharing which CASS API you used to make it work.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Marv1n

USPS.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

Thank you.