Software

Ask something
Question Locked

Web query in excel.

0 helpful
4 replies

by ahmed_zen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, can anyone help me regarding the import of web query in excel. I want to import a table from a site that shows "post" type data and is continuosly updating. My problem is that when im selecting the table through the wizard it only shows the table of that page, whereas the whole data consists of several pages (it shows 10 results per page). How can I select all the pages so that I can get the full data table in my excel?

4 replies

by absolutely

More specific details are needed about the way the table "is continuously updating" to suggest a workaround. Also, that type of behavior is typically intentional, and implies a well-maintained and scrupulously monitored server, which does not mean somebody is staring at real-time updates to the log files, but the chances are also high that if you don't get it right the first time, you'll be logged, noticed, and blocked. Finally, what you're trying to do would probably be considered 'rude' by the owner of the site; if they wanted all their data to be easily downloaded, their web designer could have more easily presented a single table or download link than making only subsets of it available. So, it's possible that they just won't allow what you're trying to do.

by ahmed_zen

Hi and thanks for replying. I think I should have been a little more specific as regards my query. Actually this is our own site and mysql query is working in the page and is based on 10 to 15 pages. I want to import the results as in tables to keep record for my accounts. So is there any way I can select all the pages and get the whole data imported?
As per its updating property the data keeps changing in minutes and secs.

by absolutely

Since it's your own site forget about the web layer and ask your db admin.

This discussion is closed to new replies.