Help with Queries and Connections, Data from Web from multiple URLs
Hello, I have a list of about 75 webpages (within the same website) from which I need to extract an specific table on each of these pages. I have been doing this one by one, (please see file attached with a sample set of extracted data) by copying the URLs which I previously extracted and placed on an excel sheet as individual links and pasting in the first query dialog box, then on the Navigator window, I select the table I want ( in this case it is consistently "Table0") and click on "load". and I get the table on a new sheet. From here I edit and sort it according to my need. BUT.... I figure that there must be a better way to automate this extraction. How do I do that? Here is the example link: http://www.usendoscopy.com/Products/roth-net-retriever---polyp.aspx There is only one table contained on each of these URLs (pictured) which lists product details but I don’t know what is the sintax I need to target it for extraction when I choose "Data"--> "Queries and Connections" --> "From Web", or if that is even the bes way to extract it.Help with Queries and Connections, Data from Web from multiple URLs
Hello, I have a list of about 75 webpages within the same website from I want to target an specific table on that page. I have been doing one by one, (please see file attached with one sample set of extracted data) by copying the URLs which I previously ewith multiple sources for Data extraction from straced and placed on an excel sheet as individual links. From there I basically copy and paste the link on the first query dialog box, then on the Navigator window, I select the table I want ( it is usually "Table0") and click on "load". ... I figure that there must be a better way to automate this extraction. How do I do that? Here is the example link: http://www.usendoscopy.com/Products/roth-net-retriever---polyp.aspx There is only one table contained on this page (pictured) which liss product details but I don’t know what the sintax is to target it for extraction on Queries and Connections --> From Web, or if that is even the bes way to extract it.
