Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2007

Tip: Looking for answers? Try searching our database.

Extracting data from web page with an imbedded DB query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jcalver - 14 Dec 2006 08:49 GMT
Hello,

I hope I can explain this so everyone can understand.  There is a
website that lists Japanese residential real estate data
(www.chintai.net), that I was previously able to use Excel's web
query function to go to all the pages, and download the data I wanted.

However, the site has recently been updated, and I believe is now using
Ajax.  I suspect this from the URL in the DB query to get the data.
Unfortunately, my Excel query is no longer able to extract the data
from the site.  The html of the page only contains the query to
retrieve the data, so Excel does not see the query results.

Is there a way to get Excel to look at the final page and then extract
data from that version?  I believe that Excel only looks at the HTML,
and with this new version of the site the HTML only contains the query,
not the actual data itself.  So there is nothing in the HTML version of
the page for Excel to extract.

The site is in Japanese, but I have included a link to the first page
of a sample query on their DB.  I want to get the table of data that
appears after a few seconds into Excel.

http://www.chintai.net/tokyo/chintai/CGI/area_list.cgi?sc=1030&ss=00000080000E00
00000000000000000001000023&st=00&sp=1


I hope that I can get Excel to properly extract this data.

If anyone has any questions, please feel free to e-mail me.

Thanks in advance.

James
alex_f_il@hotmail.com - 10 Jan 2007 19:18 GMT
You can try SWExplorerAutomation SWEA (http://WebiusSoft.com).  SWEA
supports data extraction from the Web sites with AJAX.

> Hello,
>
[quoted text clipped - 28 lines]
>
> James
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.