Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Use Office Data Connection Odc With. When using an ODC connection you establish a connection with a data source form some sort of query and import the resultant data directly into the Excel workbook. Click on Always attempt to use this file to refresh data.
ODC Office Data Connections are the traditional method of accessing data in Excel. We recommend the following approach to sharing external data sources with data shaped by Power Query. Then connect it from Power BI Desktop.
To get data from this in Access I do this.
Office Data Connection ODC files are used to store reusable connection and data query information. Then chooseSQL Sever from the listbox-menu as Driver 3. On the Select Data Source dialog box in the URL box. Then connect it from Power BI Desktop.