Hi gil.silva,
I sorted out this issue couple of days ago using Get worksheet as collection offset(same approach you suggested)
Yeah, I'm aware even using OLEDB, BP collection concatenates _1,_2 wherever it finds duplicate column names in a sheet.
Thanks for you help Man! Have a good day ahead.