Querying the USPS zipcode lookup API from Access

Hi Experts,

Has anyone developed any code to query the USPS API to lookup the zip+4 given just the street address, city & state?

I can make my way around access vba but haven't used xml etc.

Thanks for the input!

Deedub84
LVL 1
deedub84Asked:
Who is Participating?
 
HoggZillaConnect With a Mentor Commented:
Are you using the USPS Web tools from your site? There is pretty good documents on the web xml interface here:
http://www.usps.com/webtools/htm/Address-Information.htm
What specifcally do you need to accomplish your goal?
0
 
garyb2008Commented:
Hi

As a starting point your going to need to look at the Microsoft Office XML Toolkit to programatically access the webservice from VBA, msdn has some articles.

Hope this helps

Regards

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.