Question: how to open qry file in excel?
Answer: On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. The Choose Data Source dialog box is displayed.
In the Choose Data Source dialog box, click the Queries tab.
Double-click the saved query that you want to open.