download multiple pages from a web table

[arak2002]

Hi guys,
I have a good experience with Excel but not professional .

I'm trying to get/import data from a multiple pages web-table, but what I get every time is only the first page of that table. Another issue with this table is the links of the page 2 and upward are changing every time you click on them, so when I paste the link of page 2 for example, I get again the first page of that table.

This is the table: realfoods.co.uk/bulk-wholesale. The table has more than 11 pages


Any ideas? Thanks a lot and happy holidays.

[Richard Buttrey]

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

[arak2002]

Thanks for your help.

Unfortunately, I couldn't upload since the Forum requires new members to post a few times.

I can email you if it is ok with you.

Thanks again

[alansidman]

Look at this link

http://blogs.adatis.co.uk/callumgree...ng-Power-Query

I'm reading this now to learn myself

[Richard Buttrey]

...what's the web site URL?

[alansidman]

Richard,
Here is the URL This is the table: realfoods.co.uk/bulk-wholesale. The table has more than 11 pages

There is no parametized option in the address nor in the addresses for the pages 2 through 10. I tried a couple of different things including PQ with no success on getting subsequent pages. Maybe you have another option.

Alan

[arak2002]

Thank you all for your time and help.

Exactly Alan, there is no parametized option in the address nor in the addresses for the pages 2 through 10

Abdul

[arak2002]

Hi guys,
Any luck or ideas in solving the above request?

Regards,

[alansidman]

I believe your issue is not with Excel but with the web site. Since they do not appear to offer page numbers that allow parametization I see no solution. Suggest you contact the web site Admin to discuss your issue.

[arak2002]

Thank you for trying.

Regards,