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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Steve HoggITCommented:
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

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

From novice to tech pro — start learning today.