I have tried to find answers to this to no avail, if someone has posted this question before please direct me to them.
My question is how can I assigned a id/group number to a excel sqlbulkcopy upload to a sql table. What I am trying to accomplish is to associate all rows with a common ID that are inserted from the excel upload so that I can pull that specific group of rows at a later time. Let me know if I need to explain this better, thanks for the help ahead of time.