ExcelBanter - Possible to link servers with ADO or others?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Possible to link servers with ADO or others? (https://www.excelbanter.com/excel-programming/371217-possible-link-servers-ado-others.html)

Angus

Possible to link servers with ADO or others?

I am using ADO to extract data from SQL server, but I am going to make a
distributed query, is it possible to use ADO to link multi servers? How the
SQL statement should look like?

All times are GMT +1. The time now is 11:22 PM.