I'm running Office 2013 on a Windows 8-64 machine. I have a number of saved query files (dqy) that are pointing to a SQL database. In Excel 2010, I was able to open the files inside of Excel using Data - From Other Sources - From Microsoft Query - click the "Queries" tab and then select my saved file. When I try this in Excel 2013 I get errors. When I look at the SQL statement, it appears as though part of the statement is missing. I can double-click the dqy file in Windows Explorer, launching Excel 2013, and the Query runs fine. I copied the file to My Data Sources folder and tried initiating the query in Excel 2013 using Data - Existing Connections and then selecting the file. The query runs fine this way.
I'm just wondering why I can't use the Microsoft Query selection in Excel to open the file any longer. Has anyone else run into this issue?