Importing Table From A Webpage

[abhinav28]

Hi

I tried to use 'get data > from web' tool in excel to import data from this website, BT Price List .

When I did that, excel did not seem to recognise the table in the webpage. And the web view tab said 'table highlighting is disabled because this page uses internet explorer's compatibility mode'. I used to be able to do this in the past, but it does not work anymore. Can you please help me resolve this?

I know I can copy and paste the table onto excel but I would prefer to import as I want to automate this process.

Kind regards,

Abhinav

 

[sandy666]

try https://www.bt.com/pricing/current/Call_Charges_boo/2-FrameworkImpl97281.htm

Code	Charge Rate(a)	Categorisation for Customer Options (b)
300	g21	11
302	g21	11
303	g21	11
306	g21	11
330	g21	11
331	g21	11
332	g21	11
333	g21	11
343	g21	11
344	g21	11
345	g21	11
370	g21	11
371	g21	11
372	g21	11

 

[abhinav28]

Hi Sandy,

It worked.

Thank you very much for the help.

Abhinav

 

[sandy666]

You are welcome & thanks for the feedback
Have a nice day

btw. you can find frame url via Developer Tools (Internet Explorer)

or with Firefox