QV11 unable to read MS Report Builder 2012 XLSX file but QV12 works
I am trying to create a QVW application to incrementally updatea a QVD using LOAD and STORE, but I'm unable to import data from a source file (output as XLSX) created by MS Report Builder 2012.
On the same machine, I noticed a difference between QV 11 and QV 12.
QV 11 cannot even preview the source file, much less LOAD the content into memory... However QV 12 was able to read the file fine, but we can't use QV 12 yet due to licensing issues.
However. when I opened it in QV 12, I was able to preview the rows, which indicates to me that QV 12 is able to read the output.
Can someone pls tell me what is the main difference between QV 12 and QV 11 in this regards ? Does QV 12 has some additional ODBC component that allows it to detect whether a XLSX (Excel) file was generated via a 32-bit or 64-bit connector?
I can only use QV 11 and I cannot change the data source built using MS Report Builder 2012.