2.2.8.2 External Connection Files

An external connection file specifies an external connection in a separate file (external to the workbook). An external connection file enables managing connection information separately from a specific workbook and sharing it among multiple workbooks. It is used for creating a new data connection in a workbook or for restoring a lost connection. The stSourceConnectionFile field of the SXAddl_SXCQuery_SXDSrcConnFile record (section 2.4.273.65) and the rgchSourceConnectionFile field of the DConn record (section 2.4.84) specify a path to an external connection file.