Marv1n
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!!!
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!!!
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!!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Completed using the CASS API ;)
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
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.
ASKER
USPS.
Thank you.
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