Share via

why does msquery sometimes not return data to excel?

Anonymous
2012-12-12T14:13:12+00:00

Sometimes I build a query in MS query and it runs fine but when I try to return the data to Excel nothing happens.  Why is that and how can I correct it and see my data in Excel?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-12-21T13:44:13+00:00

    The import data box does appear.  When I click OK no data appears even after several minutes.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2012-12-16T01:39:24+00:00

    Hi,

    In the MS Query window, when you click on Return Data to MS Excel, an import Data box should appear.  If it does not, press Alt+Tab to refresh the screen and it should now appear.

    Hope this helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-12-13T04:05:12+00:00

    Hi,

    Thank you for asking.

    For issues related to Microsoft query in Excel you may post query in Excel IT pro forum for better suggestions:

    http://social.technet.microsoft.com/Forums/en/excel/threads

    Thanks.

    Was this answer helpful?

    0 comments