2 ms·
Excel can connect to relational databases since forever. Prehistoric versions had Microsoft Query and new ones have Power Query, which allow to build SQL. Ther
by rvba 6y ago
Excel can connect to relational databases since forever. Prehistoric versions had Microsoft Query and new ones have Power Query, which allow to build SQL.
There are also various GUI addons that connect Excel to a database. For example SAP has one in their Business Warehouse (I think they try to change into something else).
Also the "new" Power Query removes a lot of limits.