Hi, As an extension to this reading all sheets… I have an excel file with 3 different sheet names (test1,test2 and test3) which are also my table names. I want to insert the data from each sheet to a different db tables. All three sheets have 2 varchar & 1 date column. It’s reading all the excel sheets but inserting only the first table. Then the looping throws an error “included column list contains invalid column(s)!” In the DB writer, I have set the flow variable ‘Table’ as sheet. Looks like its taking the correct table but the column names are not matching with the table. Please help. [image] Thanks Venkata

Writing Excel Sheets to Database in a Loop

mlauber71 July 14, 2020, 5:49am 2

You will need two loops nested within each other, one for the Excel files, one for the sheets. These two entries might help you set it up.

Excel Sheets iterate

Excel types of loops