Link to home
Start Free TrialLog in
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!!!
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

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
Avatar of Marv1n

ASKER

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
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of Marv1n

ASKER

Completed using the CASS API ;)
Avatar of Marv1n

ASKER

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
To make the question complete would you please sharing which CASS API you used to make it work.
Avatar of Marv1n

ASKER

USPS.