Question: how to use odc file?
Answer: In Excel, on the Data tab, in the Get External Data section, click Existing Connections.
On the Existing Connections dialog box, click Browse for More.