David has attended:
Access Advanced course
Web Query
Hi
I use a web query to download tables from a web site which populates a worksheet which works fine. However one of the tables is quite a big table but I only actually need two rows from the table for my data anaylsis.
Is it possible to write a web query which only brings back certain rows from a web table?
Regards
Dave
RE: Web Query
Hi Dave
Thanks for the question
I'm pretty certain that the answer to your question is no. I have investigated the web query tool and I can see no facility for filtering the data. It would also on reflection be difficult to do as tables on a web site often lack column headings (field names) so it would be difficult to identify columns to filter.
I will however continue to explore things and if I find anything different I will let you know
Regards
Stephen
