NHL.com website; How to get tables into PQ

[DRSteele]

Can someone please help me?

I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique?

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.nhl.com/standings/2019/league

[/FONT]

 

[alansidman]

I clicked on PQ and retrieve from Web and was able to load two tables. They were listed as Table 6 and Table 7. Not sure what issues your were having.

 

[DRSteele]

Thanks for your reply, Allan.

All that the navigator shows is a yellow folder with

https://www.nhl.com/standings/2019/league [1] and under it an item called Document. There are no tables listed. What am I doing wrong? Is there some setting?​

 

[sandy666]

with url from the first post

 

[DRSteele]

Thanks Sandy. All I see is everything above your Table0.

P.S. how do I add screenshots?

 

[sandy666]

what is your excel version?

 

[DRSteele]

Excel 365 Insider Fast 1910 12126.2000

 

[sandy666]

hm, so it should work properly

on my picture you can see Display Option and Refresh Icon, use it

 

[DRSteele]

I refreshed, and refreshed...to no avail.

 

[sandy666]

I am afraid you need to start again and again from the beginning, I mean: paste url , connect etc

maybe your internet speed is too slow , I really don't know