Hi @Robotman ,
Sharing my suggestion on the issue you are facing related to iqy file.
i think we can save as iqy file into xlsx format with the help of VB code and using file format as xlOpenXMLWorkbook. Please use invoke code activity to invoke the below vb code. Try and let us know.
Once you are able to save as iqy file to xlsx use Read range activity to read the xlsx data into data table. thanks.
Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
excel = New Microsoft.Office.Interop.Excel.ApplicationClass
wb = excel.Workbooks.Open(“Your iqy file path”)
wb.SaveAs(“Your iqy filepath with the extension .xlsx instead of iqy”,Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook)
wb = Nothing
excel = Nothing