Copy paste issue

Closed
Prince - Aug 11, 2010 at 03:52 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Aug 12, 2010 at 10:58 PM
Hello,



I need an help for copying data for web page to excel sheet in ordarily manner. Could anyone help me out on this. eg. :

Name address city state and so on...

Kindly required an urgent help

Regards,
Prince

3 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Aug 11, 2010 at 05:02 AM
open empty excel sheet-use data-import external data-new web query
in the resulting window copy web page url and hit enter key
choose the particualr table in the wbe page by clicking hroizontal arrow and click import
0
Hi Venkat,

First of all I would like to thank you for reply.

I tried to collect the information, but whole page is imported, but i need only few data, like copying contact details, is there any easiest method apart from this.

Awaitng for response.

Regards,
Prince.
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Aug 11, 2010 at 09:57 PM
when you open the query you get the full web page on the window. but there will be a horizontal arrows (mostly in yellow) for each of the tables. when you click the arrow of the table you want the arrow becomes a tick mark. now you can click "import" at the bottom you get the table only in excel.

If there is problem is it possible for you to post the webpage address.
0
Hi Venkat,

Can you assist me, why I m getting error "Page cannot be displayed" when I try paste the link and click on GO.

Thanking in advance.

Regards,
Prince.
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Aug 12, 2010 at 10:58 PM
I think the problem is with the web page. It is not configured for downloading.

see whether you can highlight the whole web page or a table and copy it to excel
another way is to open the webpage in Inerent Explorer where there is provision to copy the table into excel
0