Question: how to use odc file in excel?
Answer: Start Excel 2007.
On the Data tab, in the Get External Data group, click From Other Sources, and then click From Data Connection Wizard.
Select Other/Advanced, and then click Next.
Select Microsoft OLE DB Provider for SQL Server, and then click Next.