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!!!
Marv1nAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
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
0
Marv1nAuthor Commented:
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!!
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I would recommend checking out the local mass mailing services in your area. They should be able to verify the address again the USPS address database. Not only will they get the ZIP, but the can also verify the address to be sure it is deliverable. This can sure save a lot in postage is you hav a lot of bad address.

Look for: CASS Certify and NCOA

TIP:  Some local newspapers provide this service. I would start there.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
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
0
Marv1nAuthor Commented:
Completed using the CASS API ;)
0
Marv1nAuthor Commented:
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
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
To make the question complete would you please sharing which CASS API you used to make it work.
0
Marv1nAuthor Commented:
USPS.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.