Yeah, works OK from the command window. It adds the query string correctly into the Workbook queries, it's something to do with adding a named Table that pulls from the query.
If the worst comes to the worst I can just inject the data into the sheet with ADODB ...