Insert column in OLEDB

[Malligai]

Hi, Can anyone help how can we insert sl.no column in the excel using (OLEDB)

for the n number of rows, i have to insert the Sl.no.

Thanks in advance

 

[sahil_raina_91]

Hi, Can anyone help how can we insert sl.no column in the excel using (OLEDB)

for the n number of rows, i have to insert the Sl.no.

Thanks in advance

I doubt you can ALTER Table definition via OLEDB.
However, you can INSERT the data into another sheet.

 

[sheebanancy90]

I have the same requirement. Can you send code on how to insert the data in next sheet adding value