Files ending in ODC are called the Office Database Connection File. These files are generated by Microsoft Excel to query databases.
These files are text files that contain data source information. These consist of a set of information needed to connect to a database. Among other things, the name and the server name of the database, the database driver and the necessary (login) connection information.
ODC files enable the exchange of database queries between users and are used since the 2007 version of the Microsoft Office.
They can be created in Excel using the Data Connection Wizard. This generates the connection data file in HTML, which contains segments in XML. Existing connections can be viewed via 'retrieve external data' -> 'existing connections' in the tab 'data'.
Because the files are in HTML, they can be viewed in any browser.
Most often resolving problems with opening ODC files is very simple. Just install an appropriate program that supports such files. All of the listed programs support ODC files, but may vary in offered function and purpose. Some programs may be capable only of viewing contents of ODC files or offer file conversion options, but may not be capable of editing such files.
It is possible that although a compatible program has been installed on user’s system, it is not used by the system to open it. This may happen because no default application was associated with this type of files. To associate ODC files with given application, select "Open with" from drop-down menu (accessed by right-clicking on the file). Then select from the list the program or application you want to be used to open this type of file. If the Microsoft Excel applications is not on the list, select "Browse" option in order to manually locate the directory where Microsoft Excel has been installed.
Sometimes problems with opening ODC files may not lie with the application itself, but can arise due to other causes, such as: