Using Web Service in Access 2003 (2003/SP 2)

Topic

New Reply

I have this new project where we alredy have thousands of records with street addresses coded to a proprietary geocoding system (it was based on a printed catalog) that is going away.

My goal is to be able to click on a button while viewing an address in a form and verify/retrieve the latitude and longitude. I figured on doing this with a “web service.”

While there are plenty of web sites that say this can be done, none tell me how to do it.

Does anyone have some working sample code? After my company tells me what mapping program I will be using, I can change a few URLs.

Thanks bunches!

Reply | Quote

Replies

Alan

In my experience, the easier way of doing this is to use Excel 2003. Click DataImport External DataNew Web query. Put in your URL, select the area of the data you need & it will download into the worksheet. You can then paste this into your Access table.

If you know enough VBA, you can automate this process. I can supply some code if you are interested.

Nick

Reply | Quote

Thanks … If I had the option of using Excel it would already be done.

The problem is that this will be on-going. As a phone operator takes the info about a problem over the phone, they will be taking new addresses that need to be verified.

I have a chunk of Excel code to do a global lookup.

Anybody else??

Reply | Quote