Microsoft, Access, 2000 How to Calculate an aproximation of the Distance between two zip codes using a query to Google Maps

My Company does not need a profesional mileage system like PC Miler, but I oftentimes need to calculate the distance over the road between two zip codes.
is there an easy way to return the information using something like google maps?
Ideally I have a form, I enter two zip codes and then click  and the query is created, submited and displayed
LVL 10
TOPIOAsked:
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.

jderaCommented:
0
TOPIOAuthor Commented:
dear Idera:
The solution has to work for Microsoft Access 2000 and purchasing a package for all the users who might use this function is not an option
0
aesmikeCommented:
TOPIO,
Check out the attached MDB.  It's got all you need.
IMPORTANT: This is actually a ZIP file --NOT a TXT file as the name implies.  EE doesn't allow ZIP files to be uploaded, apparently (don't know why!)
After downloading, change the TXT extension to a ZIP.  Then extract the MDB within it.

As a general comment, you should look towards a web service or something like that.  This way it's dynamic.  Otherwise, you have to get periodic updates whenever ZIP codes change and you have to maintain this data yourself.  Just a thought.

-Mike


zipcodes.txt
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jeffrey CoachmanMIS LiasonCommented:
aesmike, TOPIO

Just to clarify,

EE-stuff.com, does allow zip file uploading.
(EE) aka: Experts-Exchange.com's "Attach File" utility does not. (yet)
(Don't know why either!)
;-)

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
aesmike,

Actually your DB is nicely done.

Clean and neat!
:)

Jeff
0
TOPIOAuthor Commented:
Excellent, Fas Neat and It works
What more can you ask for?
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
Web Development

From novice to tech pro — start learning today.