Overwrite Rows with Duplicate Values in 1st Cell

[stmur]

Good Day all!

Here is the situation

I have data in single rows, about 60 col wide and each row has a unique serial #
I need to open a master database, and copy the rows in the first file into the db

That is all simple enough, but:
If there is already a row in the master db with the same serial # as one of the incoming rows, i need it to overwrite that row with the new data.

Hope this makes sense!

Thanks to anyone who takes the time to think about it (and to those who don't have the time )

 

[stmur]

mmm, looks like it might be harder than i thought..

Or is there a way to search for the incoming serial numbers, and if they exist, delete row, or just modify the old serial number with an R prefix (for replaced)?

Pleeez help!