Open OQY files

  • Full name
    Microsoft Excel OLAP Query Format
  • Developer
    Microsoft
  • Popularity
Have you encountered a problem with a OQY file? Don’t you know which program opens a file with this extension? You will find all the information you need about working with a OQY file here. In the further part of this page we have added a list of programs that should open your OQY file. It is enough you choose a proper application for your operating system, download and install it.

What is OQY file?

The extension OQY denotes OLAP Query files from Microsoft Excel. These files are text files that serve database queries. They contain data source information that consists 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.

More info

OQY files allow the exchange of database queries between users.

OLAP (Online Analytical Processing) is a method of analytical information systems. It is intended for the fast processing of multidimensional analysis queries. OLAP is part of a category of business applications called Business Intelligence.

Microsoft Excel supports various file types for database queries with the extensions rqy, dqy, qry, and iqy.

Programs which can open a OQY file

How to open file with OQY extension?

In order to open a file with OQY extension one of the following programs must be installed on user’s system. If a problem with opening OQY file occurred, it is highly possible that none of the listed programs is present on user’s system. Even if one or more said programs are installed, there may be issues related with given programs. In order to solve a problem with OQY files, follow the instructions below.
1
Install Microsoft Excel or other program from the list

Most often resolving problems with opening OQY files is very simple. Just install an appropriate program that supports such files. All of the listed programs support OQY files, but may vary in offered function and purpose. Some programs may be capable only of viewing contents of OQY files or offer file conversion options, but may not be capable of editing such files.

Set Microsoft Excel as the default program for opening OQY 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 OQY 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.

2
3
Check the section that lists most common problems with OQY files

Sometimes problems with opening OQY files may not lie with the application itself, but can arise due to other causes, such as:

  • File data is corrupted
  • OQY files has been not been completely download from the internet (only a part of the data has been downloaded)
  • Currently used user account hasn’t been granted necessary privileges to open OQY files (should that be the case, please contact your system administrator or IT specialist)
  • OQY file was being copied from a corrupted storage device and is incomplete or data is corrupted. (Copying files from unknown or untrusted sources should be conducted with great care as such files may contain malicious software, which can damage your system)

Similar extensions