Problem: I am loading a regularly produced excel file which is produced with 2 grouped worksheets (ie the bar at the top of the Excel window contains [Group]). Using the Table Files wizard I can load all rows from the second sheet, however when I attempt to load the first sheet only the heading row is returned.
If I open the Excel workbook and click on either of the sheets (thereby ungrouping them) and resave the workbook, I do not have the problem. However, these files are regularly produced and this is not practical.
