I'm trying to find a way to UNION (or get the affect of a UNION) 2 tables in Excel. I found a solution that initially sounded like what I wanted using PowerPivot in Excel, but that method is using 2 databases from the same server. What I need to be able to do is the same, but using data from 2 totally different servers which are not linked to each other, so I can't just do it via a linked server.
Also, it looks like that example is using OPENQUERY which apparently can only be used on Linked servers. Even if the servers were linked, last I checked, that FUNCTION is specifically disabled for security reasons.
Does anyone have suggestions? Of course, I could manually append the data to Excel, and then use Data - Remove Duplicates. The total record count should be small enough to not be a big deal, but I wanted to use this instance as a learning tool for bigger such requests I might get in the future.
Thanks for any thoughts
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
Also, it looks like that example is using OPENQUERY which apparently can only be used on Linked servers. Even if the servers were linked, last I checked, that FUNCTION is specifically disabled for security reasons.
Does anyone have suggestions? Of course, I could manually append the data to Excel, and then use Data - Remove Duplicates. The total record count should be small enough to not be a big deal, but I wanted to use this instance as a learning tool for bigger such requests I might get in the future.
Thanks for any thoughts
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57