I used Microsoft Query and wrote a query to our MSSQL database. The query works great in MS Query. It's about 59,000 rows and 9 columns of data. When I close MS Query and it goes to import the data into Excel, it says: "Getting Data" for a few seconds and then just disappears. No data ever actually shows, but it's almost like Excel seems to think there is something there.

I've tried on Excel 2007 and 2010, but both do the same thing. I've read that Excel 2007/10 can handle up to a 1,000,000 row query, so I'm not sure why it's not working here.

As a side note, I can run every other query (smaller) with perfect results.