How do I open an ODC file?

Files in ODC format can be opened with Microsoft Excel 2011 and Apple Safari in Mac OS platforms. And they can be opened with Microsoft Excel 2010 and Microsoft Internet Explorer in Microsoft Windows platforms.

How do I import an ODC file?

Using File Explorer, locate the ODC file created in the previous section, and then double-click it. Excel opens the ODC file into a new Excel workbook. If you get a message about trusting the data source, select Enable. In the Import Data dialog box, decide how you want to import the data, and then select OK.

How do I use ODC?

To use an ODC file as a data source in Excel On the Select Data Source dialog box, in the URL box, type the URL for the library where you saved the ODC file, and then press Enter. It may take several moments for the list to refresh with content from the specified location.

What is an ODC connection?

The ODC file extension is known as Office Data Connection File which was developed by Microsoft. The file format is a connection information file that contains properties to connect to, and retrieve data from an external data source or a Reporting Services Report.

What is an office Data Connection ( odc ) file?

Office Data Connection (ODC) files are used to store reusable connection and data query information.

How do I create an ODC file in Excel?

ODC files can be created using the Data Connection Wizard in Microsoft Excel, which generates the connection information using HTML markup with included segments of XML. Existing data connections may be viewed in Excel by selecting Data → Connections.

How to share external data using an ODC file?

Share external data by using an ODC file (Power Query) 1 Step 1: Import data and save connection and query information to ODC 2 Step 2: Open and use the saved ODC file More

What are the advantages of using an.odc file?

One of the advantages of using .odc files is that any updates to the external data connection properties only have to be done once in the .odc file itself – any workbook using the .odc file for its data connection will use the updated connection properties.