Forum Discussion
importing data and power query
Just to start, I am not very good with Excel. However I regularly import order information from DATAFILS .RPT, the excel import wizard transfers the data to .TXT file, then I can save it as an Excel...
JcLudden That's exactly what PQ is for. Connect to the .rpt file (which is just a text file), do all your transformations / clean-ups in the PQ interface. Close and load. Save the file. Next time, when you get a new .rpt file (same name, I suppose and in the same location), open the workbook that contains the query. Refresh All. That's it.