Results 1 to 3 of 3
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

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

    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 <font color=red>how</font color=red> 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!
    Alan

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

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

    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??
    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •