I am trying to get data from this site and import it into excel or aceess.?

Question

I am trying to get data from this site and import it into excel or aceess. the site link is as follows:

http://www.egyptse.com/index.asp?CurPage=todays_market_watch.asp

Answer 1

http://blogs.techrepublic.com.com/msoffi...

Answer 2

Hi,

This is possible using screen scraping techniques. Basically you have to traverse the DOM of that page and since the data is in a table, you write your logic based on that.

You can make a SOAP call using PHP and then traverse the DOM using PHP DOM functions. Then you have to write that to a Excel sheet. PHP has a module for writing to excel sheets.

I can do this for you (for a price) if interested let me know.