Thank you joseph_michaud!!! That solved it.
I added ';IMEX=1' which did the trick.
'Qry.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + path + "; Extended Properties ='Excel 12.0 Xml;HDR=YES;IMEX=1' ";'
What are you getting as the column names? My guess is the column names are either blank or 'Product 1' or 'Product 2.' That's because Excel column headers should be in the first row and not the second. Try removing the first row from the spreadsheet and see what you get.
To verify my above assumption, I took your spreadsheet and created a Table Data variable and created a DDT loop with it. Then I added the Append Log Folder command in a Keyword test. The names of the Excel Columns were F1, NoName' F3, F4, Product1, etc. (Basically the first row of your spreadsheet.)
For column names I am getting F1, NoName, F3, F4, etc which is fine. Since I am downloading this file from a server, I don't want to modify the file, I want to verify the names of the second row which includes Accounts, ID, MarketVolume etc but I am getting mostly blank results when it loops through. The strange thing happens where the third and following rows get printed like expected, but the second row does not.
