How To Use Excel with SQL Server Linked Servers and Distributed Queries

SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. The persistent connection is known as a linked server; an ad hoc connection that is made for the sake of a single query is known as a distributed query. Microsoft Excel workbooks are one type of OLE D

Read More - Register for Free Membership