Solved Excel now greys out Import data from Microsoft Query -- Now solved

Hi there
Running this version of Ms Excel / Office and it's on Windows 2022 LTSC server so it's DEFINITELY not caused by any recent build by Windows 11.

Windows build -- Windows server 2022 -- running as a workstation OS !!




Office is activated -- top line means in English Product activated and I've squiggly underlined the version info

Now when I try to get data from a remote MariaDB (equiv to MySQL) database you just use the Get data and from the other sources use the From microsoft query. You then get prompted for data source / create a new one -- I've got the proper OBDC driver which works properly) it's now greyed out.

It works fine using Office 2019 though. So it's broken - or is this another attempt to get people to subscribe to Office/365.

Office 2019 :



so new DSN (data source), OBDC driver and remote connection all OK

and data returned to EXCEL




Cheers
jimbo

Hi folks

Issue is solved -- on a hosts file I had the local host (127. etc) in the web server as

# Static table lookup for hostnames.
# See hosts(5) for details.
127.0.0.1 localhost
::1 localhost
127.0.1.1 wrongname <========I had same name as the the REMOTE computer name so whole thing got hosed up.

All fixed and working -- marked as solved -- really "Baby" error that one.

cheers
jimbo