ASP XmlHTTP: Specific Table Data Receiving from Other site.

<%
url = "http://www.url.com"
set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.open "GET", url, false
xmlhttp.send ""
Response.write xmlHttp.ResponseText
set xmlhttp = nothing
%>

What i want to know is, what code do i need to add or edit so i can display data from that site in specific table.

The table is is "Table1"

Please help me. Remote site has table and i only want to show that. The above code works really fine, but shows everything. I just want one table.

Help.
Regards

 

In order to display part of the code you will have to parse it manually using string functions. Look at the part of the code that you want to retrieve and work out a way of uniquely identifying that part of the code e.g html tags or attributes that identify it uniquely. Then use string functions like: Instr() and Mid() to get the part of the html that you want.

 

If you post the URL of the page that you want to retrieve and describe which part that you want to retrieve I will be able to help you further.