This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
I have been using MS Query MSQRY32.exe to access data in a 32 bit database using 32 bit DSNs for 30 years. Today I find that MSQuery has been removed from Excel-GetData-From OtherSources. MSQRY32.exe works if I run it directly. It is simply missing from 365 Excel. How do I restore the MSQuery option to Excel-GetData-From OtherSources.
It is Office 64 bit, but MS Query isn't available at all. I have always (as in 30 years) been able to use MS Query in Excel to access either 64 bit or 32 bit databases. The DSN is 32 bit as the database is 32 bit and the database software supplier has provided a 32 bit ODBC driver.
Thanks for this reply, Olaf :-)
I understand your point though. I am probably using MSQuery64 with Excel 64 bit and the driver is doing the 32 bit datacall.
Hi,
Is the reply of Olaf Helper helpful? If yes, I suggest you mark it as answer. Other partners who read the forums with the same issue can get more information from the correct result.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPE%3C/text%3E%3C/svg%3E)
Rather see André's answer (Apr 2, 2024 5:58PM) - simple solution to Microsoft's god-complex hide-and-seek shenanigans!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 98%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
I finally managed to solve my issue by going to File / Options / Data / Show legacy data import wizards, and ticking the box for "From Microsoft Query (Legacy)"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 82%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Thank you Andre! Worked Perfectly. I also have used this from day 1. Was upset when I couldn't find it. Thanks, Microsoft for playing hide and seek once again with features. I need this for my job.
Thank you, André - quick solution. :)
I thought I was going mad!!!
Brilliant Andre. Really appreciate your answer.
Is you Office 64 bit? Then MS Query 32 bit isn't available/usable.