Question:

Am trying to get data from this site and import it into excel or aceess?

by  |  earlier

0 LIKES UnLike

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

 Tags:

   Report

4 ANSWERS


  1. have you tried just....copying the entire table, and pasting it into excell?

    usually tables copy properly into spreadsheets

    just copy and paste as if its normal text


  2. Highlight the whole table, or the portion you want.  Copy it.  Paste it into Notepad (to get rid of the formatting).  Highlight the whole Notepad document (ctrl-A).  Copy it.  Paste it into Excel.

  3. Your best bet would be to copy/paste it. It won't let you download it so there really isn't any reaso to try.

  4. The site does not appear to support downloads - sorry

    The tip above works  - Nice idea!!!

Question Stats

Latest activity: earlier.
This question has 4 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.