[QODBC-Desktop] Troubleshooting - How to enable Microsoft Excel 365 - Legacy Microsoft Query

Problem Description:

I am using Microsoft Excel 365 and trying to import data using the Microsoft Query option. However, I cannot find Microsoft Query (Legacy) under the Get Data tab.
Why is Microsoft Query (Legacy) missing in Excel 365, and how can I enable it?

Solution:

In recent versions of Microsoft Excel (including Excel 365), the Microsoft Query (Legacy) feature is hidden by default from the Get Data tab. This tool is commonly used to import data from external sources via ODBC connections. If you're using QODBC or any ODBC-based system like QuickBooks, enabling this option is necessary.

Note: We recommend using the 64-bit version of Microsoft Excel for better performance and compatibility when working with large datasets.

Prerequisites:

Microsoft Excel 2016 or later (including Excel 365)
Administrative access to change Excel options.

As shown in above image, the Microsoft Query option does not appear under the Get Data tab by default.

Step-by-Step Instructions to enable Microsoft Query:

Step 1: Enable Legacy Data Import Wizards.

• Open Microsoft Excel.

• Click on the File tab.

• Click on Options at the bottom-left corner.

• In the Excel Options window, select the Data category from the left-hand panel.

• Scroll down to the Legacy Data Import Wizards section.

• Check the box labeled "From Microsoft Query (Legacy)".

•  Click OK to apply changes.

•  Close and restart Excel for the changes to take effect.

Step 2: Access Microsoft Query (Legacy)

After restarting Excel:

• Go to the Data tab.

• Click Get Data > Legacy Wizards > From Microsoft Query (Legacy).

By following the steps above, you can restore and use the Microsoft Query (Legacy) wizard in Excel 365, allowing seamless data import via QODBC from external applications such as QuickBooks.