copy html table to excel, missing hyperlink

Hi,

 I trying to copy the contents of a webpage to an excel document.
 
The webpage consist of a html table with fields such as website and emailto:.

I perform the following:
- 1 highlight the webpage html table.
- Ctrl +C "Copy"
- Move to excel 2003, Ctrl + V ( Paste )
- All the data is successfully copied to the excel cells, but the hyperlinks beneath website and emailto: are not copied.

Any ideas?
thanks
Ed
geeksupportAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Wayne Taylor (webtubbs)Connect With a Mentor AstronautCommented:
Ed,

Use the Web Import tool....

1) Go To Data > Import External data > New Web Query....
2) Enter you URL, then click Go.
3) Click the yellow table markers to choose which table/s to import
4) Click the Import button
5) Select where you would like it to go, then click OK.

Wayne
0
 
geeksupportAuthor Commented:
Thanks Wayne,

 It is getting me closer.

 Hope you can assist further to close the loop for me.

 I'm looking at

- www.mychild.gov.au

->on the bottom right -> "find a local child care service" -> "search now"

-> in the "state" drop down, select "south Australia"

-> click in "search.

I would like to tabulate the returned data into excel spreadsheet to later convert to csv for importing to a mysql database.

Somehow the method you outlined doesn't collect the data. Maybe I'm doing something wrong.

Your assistance is appreciated


0
 
Wayne Taylor (webtubbs)Connect With a Mentor AstronautCommented:
Hmm, I don't think there's anything we can do with that site because they are doing things in the background, which is of no use to us at all.
0
 
geeksupportAuthor Commented:
Thanks Wayne,

 For looking into this.

 What do you think is the best way I can collect the data.

 Manually cut and paste?

cheers
Ed
0
 
Wayne Taylor (webtubbs)AstronautCommented:
Yeah, I think the easiest way is a manual copy/paste.

Wayne
0
All Courses

From novice to tech pro — start learning today.