I have no issues using Data Connections in Excel 2010 most of the time, but occasionally when I get external data via Microsoft Query (via SSMS), the query results will display fine in the GUI, but when I click export to Excel, The "Query from [database]:Getting Data..." will drop off the Getting Data part and return no results.
It simply says, "Query from [database name]". Has anyone had this issue before and how do I resolve it? Often times, I have to simply restart my PC or try again later, and it will work. Any ideas?
It was because part of the script created messages (1 row inserted, etc.). I put "set nocount on;" at the top of the script which removes these messages, and I haven't had a problem since.