This seems to be a problem for a lot of people, as there are at lot of pages asking how to fix this issue. The issue is that when you want to create a new query or edit a query that pulls data into Excel, Excel will attempt to launch MSQuery and hang, only displaying the message "waiting for data to be returned from microsoft query".
Here is a very simple workaround:
1) First of all, create your query in MSQuery directly, then save the query somewhere.
2) Go to Excel, select Data --> Import External Data --> Import Data
3) In the "Select Data Source" dialog box, do not select the odbc connection to the db, instead select the query you created in MSQuery.
That's it, the data will now import correctly, and the profile will save into your Excel worksheet as normal. Just thought I'd share this as I haven't seen a solution posted anywhere.
Subscribe to:
Post Comments (Atom)
7 comments:
My god... I've been trying to find a way to fix this for nearly 2 weeks now. I've found several false hopes but yours worked. IT WORKED.
Thank you, thank you, thank you.
Really glad it helped you. This problem drove me crazy for a while too, and I couldn't believe no one had posted a solution for it yet!
But what if you data does come from an OBDC table?
This does solve that problem - by creating the connection in MS Query, you are creating your connection to an ODBC table, and it IS a live connection, but you are creating it externally, so it works around the bug in Excel itself
Thanks for your rapid response, but in my version of Excel 2010, there is no Import External Data after Data.
only have Data -> Connections or Properties
Thanks But here isn't no Import External Data option in Data Page (excel 2016, excel 2007). Could you please tell me where is "Import External Data"?
I've recently developed the issue you described.
It's surprising that MS has not fixed it after all these years.
Anyway, thank you for your workaround solution.
Post a Comment