With office 2011 for Mac I am trying to import the table from this site;http://www.pgatour.com/r/stats/info/xm.html?120
with the "Get external data" and saved query.
I read somewhere that you can edit the sample files in the Query folder, so I tried this like below, but it doesn't work.
WEB
1
http://www.pgatour.com/r/stats/info/xm.html?120
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
I tried importing some other sites and it works perfectly, but not with the site above, that I want to import.
Any help much appreciated.
with the "Get external data" and saved query.
I read somewhere that you can edit the sample files in the Query folder, so I tried this like below, but it doesn't work.
WEB
1
http://www.pgatour.com/r/stats/info/xm.html?120
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
I tried importing some other sites and it works perfectly, but not with the site above, that I want to import.
Any help much appreciated.
