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
Related Tags
excel × 158sql-server × 65
ssis × 17
mysql × 15
import × 15
sql-server-2008-r2 × 12
ms-access × 12
sql-server-2008 × 10
ssms × 10
sql-server-2012 × 9
oracle × 8
export × 8
database-design × 7
vba × 7
postgresql × 6
ssas × 6
sql-server-2014 × 5
sql-server-2016 × 5
csv × 5
openrowset × 5
ms-access-2010 × 5
etl × 4
odbc × 4
permissions × 3
sql-server-2005 × 3