3,915 questions
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)"
MSQuery is has gone from GetData From Other Sources in Microsoft 365 Excel
![](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)
Roger Lewis
40
Reputation points
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.
Microsoft 365 and Office | Excel | For business | Windows
{count} vote
-
Roger Lewis 40 Reputation points
2024-03-30T05:06:35.31+00:00 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 :-)
-
Roger Lewis 40 Reputation points
2024-03-30T05:08:46.4433333+00:00 I understand your point though. I am probably using MSQuery64 with Excel 64 bit and the driver is doing the 32 bit datacall.
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2024-04-01T01:41:21.7166667+00:00 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)
Peter England 5 Reputation points2024-04-26T10:03:37.68+00:00 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(284.8, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Greg Devine 0 Reputation points2024-06-03T17:32:12.7233333+00:00 I tried this and every time I try to invoke msqry32 my excel goes WSOD (white screen of death). Doing another update and reboot now.. praying it fixes the issue. This crap is why I use linux at home.
Sign in to comment
Accepted answer
-
![](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)
André de Oliveira Schram 130 Reputation points2024-04-02T16:58:19.1066667+00:00 -
![](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)
Gary 10 Reputation points2024-04-04T13:16:38.35+00:00 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.
-
Peter England 5 Reputation points
2024-04-26T09:58:34.2533333+00:00 Thank you, André - quick solution. :)
I thought I was going mad!!!
-
Roger Lewis 40 Reputation points
2024-04-26T11:55:48.54+00:00 Brilliant Andre. Really appreciate your answer.
-
![](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(176, 34%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sunni Goodreau 0 Reputation points2024-05-14T17:18:06.4433333+00:00 THANK YOU SO MUCH!!! Another work around is to drag the query file (the .qry file) into the body of a workbook - but for those of us who are already MSQRY experts, this is the perfect solution. YOU ROCK!!!
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Olaf Helper 47,441 Reputation points2024-03-30T04:53:22.78+00:00 Is you Office 64 bit? Then MS Query 32 bit isn't available/usable.