x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 30 subscribers
  • Views 77 views
  • Users 0 members are here
Browse Forums
Announcements
891
topics
177
replies
General Discussion
2k
topics
5k
replies
Renier Theron

Microsoft Excel 365 32 bit create ODBC query

SUGGESTED
Posted By

Using Office 365, we used to be able to write ODBC queries in Exccel by going to Data -> Get Data -> From Other Sources -> Microsoft Query.

After a recent update, the "Microsoft Query" option is no longer there?

Please confirm which option should be used to create ODBC queries?

  • 0
    SUGGESTED

    Seems like Microsoft is retiring the MS Query option...

    Tannie google gave me this answer: "I was able to get it back by File>Options>Customize Ribbon> Select All Commands at the top and scroll down to Legacy Wizards (not MS Query) and add it to you Data tab. It may prompt you to create a New Group to add. Then I was able to rename it to MS Query Legacy."

*Community Hub is the new name for Sage City