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.