I didn't look at your file so you have me at a disadvantage there.
"Case near T1" is the error message?
You are trying to use exactly what you posted even though the file path and range doesn't apply to you?
Your version number can be found in C:\Program Files\Microsoft Office xx
EDIT - apparently the reference to 8.0 isn't an error. I tried this using 15 and got an error about not being able to find an ISAM. After switching back to 8.0 that message is gone. At the moment it's complaining about the range value I used, so I can at least say that the file path and 8.0 reference is correct.
Eventually I got data returned as long as there is a range defined as in A1:B1 However, I don't care for the symbols it returned (#) for decimal points nor the fact that even after I closed the query Access held a lock on the file. Methinks I would try TransferSpreadsheet instead.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.