I need to retrieve fields "Preiod", "Arrears Rate" and "Refund Rate" from Sheet called "CRA Rates" in an external (closed) workbook.
I have a data connection, which retrieves ALL fields from the above-mentioned location. However, I only need the 3 fields mentioned above.
I tried modifying my Query by:
1) Changing "COMMAND TYPE" to SQL, and
2) Typing in the command: SELECT 'Period', 'Arrears Rate', 'Refund Rate' FROM 'CRA Rates$';
Unfortunately, I got syntax errors, and so had to change the command type back to TABLE.
Would appreciate any kind of help on this - i.e., Query-edit and/or VBA code
(This used to be way easier/simpler in the good old days of Excel 2000.)