I have a data extract that is in the format of an Excel workbook. The file is exported from a web interface by a person. I am importing this extract into SQL Server via SSIS. The problem is that there are two columns on the worksheet that have the same name. I need a way to find the the second instance of the column name and tack a "1" or something to the end of the field name. I would also like to programatically change the tab name.

I was thinking of a template file that the user could paste the exported data into, then run a macro to rename that second field and the tab, then save the file as normal.

Any ideas?

Thanks

PK