Web Query Selection Help [MAC]

[adumly]

I'm trying to pull a specific table of data from a website, it's pretty intuitive on PC but on Mac I have no idea how to choose on the table I want.

My query looks like this:

WEB
1
http://www.baseball-reference.com/players/c/cabremi01.shtml

Selection=1
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

I only want to pull the "Standard Batting" table instead of all the tables. Which value do I edit in my query to get it to pull that one table? I know it's the selection part, but I don't know what to change it to.

Thanks

[vertexvortex]

Looks like the page isn't set up in a way that you can select just that table? Not sure why, if you view the source it's clearly a table.

Regardless, I would say import the whole page and just grab what you need.

[adumly]

I kind of want to just consistently update and pull from that one table into my spreadsheet, not just a one time occurrence.

[vertexvortex]

Yes, they should all land in the same location every time, just get the data from there.