I'm trying to import some data, simple enough right? Well maybe for some of you.
I exported some of the columns to Excel. They were updated and now need to be imported. The problem is that I can't/don't want any duplicates and can't delete and update because I only exported some of the columns. Bacially I need to tell it that if Column#1 Row#1 from the excel has a match in Column#1 on table, to change the data in that row in the apropriate column; If Column#1 Row#1 from the excel doesnt match then add it.
I hope all that makes sense to somebody. I'm new at SQL so any help at all would be great.
Thanks
Dodge
I exported some of the columns to Excel. They were updated and now need to be imported. The problem is that I can't/don't want any duplicates and can't delete and update because I only exported some of the columns. Bacially I need to tell it that if Column#1 Row#1 from the excel has a match in Column#1 on table, to change the data in that row in the apropriate column; If Column#1 Row#1 from the excel doesnt match then add it.
I hope all that makes sense to somebody. I'm new at SQL so any help at all would be great.
Thanks
Dodge