I have the following iqy file:
https://foo.bar.com?sid=["sid"]
Selection=1
Formatting=None
when I try to import it it asks for the sid parameter which is stored in another sheet. so far so good.
But I don't understand which parameter I have to enter on the Selection part. I tried 0, 1, "Table 1"... it does not seem to work. Selection=1 seems to pull the whole page
when I import the data manually using "get data from the web" I get the following tables:
the one that I am interested in is "Table 1"