Hello everyone, I have 2 excel file and I want to add the data of the first excel file to another excel file. I’m using Add Data Row but I can’t achieve what I want. [image] I want to add the data of A-C to the another excel file that has a “Employee Details” sheet name then add the data of D-F …

Adding Data Row to another excel file

muthuraj.c (Muthuraj) September 23, 2022, 2:11am 2

Try This,

DT_Input.DefaultView.ToTable(False,“Invoice Code”,“Category”,"Department")

Thanks,
Muthuraj

1 Like