How to read data from owssvr.iqy?

I am downloading data from SharePoint in format to read data owssvr.iqy
please help me on this.

Ranjith Ratnala

I think you directly cant read *.iqy files but you can use Excel to open *.iqy file and save it as xlsx file extension and then use the file to process.


I am facing the same problem. Can anyone help on how to open the .iqy file in excel and save it.

Hi Meenashi,
we have write separate macro code for this.

Hi All,

I solved this issue by using Excel application scope, include the path of the.iqy file. We need to copy the sheet from the location where we have .iqy file and paste it in a new excel for us to reuse.