Other users don't need to set up a data source to open the connection file, but they may need to install the ODBC driver or OLE DB provider required to access the external data on their computer.ODC files are the recommended method for connecting to data and sharing data.You can easily view or edit the contents of the file in Office Excel.
Connection information is stored in the workbook and can also be stored in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Data Source Name file (.dsn).
Using query files You can save files to connect to data in an OLAP database, either on a server or in an offline cube file (.cub).
When you use the Multi-Dimensional Connection Wizard in Microsoft Query to create a data source for an OLAP database or cube, an file is created automatically.
This external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, and access the external data source.
The main benefit of connecting to external data is that you can periodically analyze this data without repeatedly copying the data, which is an operation that can be time-consuming and error-prone.