Good day,

I am looking for ideas as to the best approach to achieve the following:

History:
1.)I am copy pasting data from an excel to an Access table
2.) tables to queries to report the usual behind the scene stuff
3.) From time to time the data might be replaced with new data
( this will be completely remove old data and paste everything new data)


On the report I have the following details:
(Item, Quantity, Size, Desciption)

I was thinking if I was to create a table (to store wanted editing changes, to avoid changing the orginal data over and over on every new paste)
Column A, Column B

if A = Description replace with B otherwise keep A

I am hoping for a little guidance, thoughts or ideas.

Cheers,