TOPIC: RQA/RAT connection to Excel doesn't work - Solution

RQA/RAT connection to Excel doesn't work - Solution 2 years 10 months ago #76

  • 's Avatar
Hi everyone!

We detected an important issue regarding the RQA connection to Microsoft Excel requirements repository: Microsoft Office 2016 technology that allows RQA extract the information from Excel workbooks (.xlsx format) has changed from previous versions. Unfortunately, this means that RQA does not work with .xlsx format documents created by Excel 2016.

The solution is to install the Microsoft Access Database Engine 2010 Redistributable:

You have to select the same architecture than your current Office 2016 software (32 bits or 64 bits).

UPDATE: we have discovered that, even installing the 64 bits version, it is necessary to install the 32 bits version. The reason behind that is that RQA is workng on 32 bits architecture and Office is on 64 bits.

However, it is not as simple as just double-clicking in the file, because it will warm you that your current version of Office is 64 bits. In that case, it is necessary to run the file by command line, using this command:

AccessDatabaseEngine.exe /passive

The /passive command will run the file without interaction with the user, so it won't warm you as the last time.

And finally, to make it work in RQA, you have to quit the application and start it again.

Now the problem is solved!

Last Edit: 1 year 5 months ago by lmalonso. Reason: Punctuation
The administrator has disabled public write access.