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.