New answers tagged excel
0
You want to merge the data, in database terms it is called joining tables. If you want it non-script please refer here
to get a understanding how to do it non-scripted on MS-Access.
0
It's not entirely clear what part of the stack your question is on. Assuming you're running a second server in parallel with SQL Server 2019 with MDS 2019, then you can certainly connect to either instance in parallel. Specifically here's the download for the Excel Add-In for MDS 2019 which should be backwards compatible to connecting to your MDS 2016 ...
Top 50 recent answers are included
