Question: how to create odc file for excel?
Answer: 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. On the Data tab, click Connections.