I am reading all the sheets of an Excel file using flow table row to variable loop start and then writing every sheet as a table in Access database. I want my table names to be same as the sheet names. Can anyone suggest how to do it.?
I connected a "Flow variable port" from Table Row to Variable Loop Start to Database Writer. When i try to select "sheet" as "table" in "Flow Variable" tab it shows the following error:
"Invalid Settings: Configure node and enter a valid table name."