[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/03/2009 at 09:35AM PST, ID: 24867996 | Points: 500
[x]
Attachment Details

Retrieve geolocation XML data from web into Access

Asked by pand0ra_usa in Access Coding/Macros, SQL Query Syntax, Extensible Markup Language (XML)

Tags: Access XML Web Geolocation, Microsoft, XML, Access, SQL, geolocation

I have a table in Access that has a list of IP addresses in one column. I also have a query of unique IP Addresses. The goal is I want to append the XML data from the URI to the query below so that I have a table that contains unique IP addresses and the XML geolocation data. As I import new logs I need to be able to update the unique IP Addresses and the geolocation information. Right now there are about 700 unique IP addresse and I need to get the geolocation info for each of them.

(
SELECT DISTINCT IPaddress
FROM HeuristicsDaily;
)


URI: http://ipinfodb.com/ip_query.php?ip=173.88.133.54  (or whatever the unique IP Address is)

Table Name: HeuristicsDaily

Column name: IPAddress
[+][-]11/03/09 10:36 AM, ID: 25731955

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 10:56 AM, ID: 25732185

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/03/09 11:33 AM, ID: 25732594

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 12:50 PM, ID: 25733446

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/03/09 01:07 PM, ID: 25733656

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 01:32 PM, ID: 25733999

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/03/09 01:41 PM, ID: 25734107

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 02:15 PM, ID: 25734421

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625