Question: how to create odc file?
Answer: To create and publish an ODC file In Excel, on the Data tab, in the Get External Data section, click From Other Sources, and then select your data source. Complete the wizard to create a data connection to your data source.