Avatar of Marv1n
Marv1nFlag for Afghanistan asked on

Urgent Assistance Needed - Excel/Access Address Verification


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.



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.

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
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


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

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.

Completed using the CASS API ;)

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.

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

Thank you.