How to write the data from different excel sheet to Database

Help
,
1

Hi,

I need to insert the data from Excel with different sheets(Sheet1,Sheet2…) to Database(Different column). Sheet1(Excel) - Column1(Database)…
Can anyone help me out?

Thanks,

2

do you have multiple sheets in excel.
if it’s still 1,2 or 3. maybe you can use the read range activity for each excel sheet.
I know this is not optimal.

3

Hi @Mulya_Habibi_Tullah,

I have different sheets in Excel file.

4

@Meghashree_H_R

Initially, u can initialize the dictionary dict variable(like sheet1:Column1 and Sheet2:Column2)
Next use for each, inside for each u can take read range to read the sheets by passing dict(0).key and u can pass data in database using dict(0).value

Regards,
Kumar.