Hello,
Unfortunately it is no longer possible to add an ODBC query in Office365. Excel always makes it an OLE DB query and then shows the following query properties:
If I now create the file in Office2013, then "database query" is displayed for connection type:
Because Office365 uses OLE DB, I can no longer retrieve the data in Office2013.
Best regards
Markus


][1]
