Append changed data into a history table

[Travis]

I recieve a daily data file from an vendor on daily legal activity. I need
to bump this file against the current status table which contains information
on thousands of legal accounts. I need to know if the status of a legal
filing changes and when the change occured. I would like to have a history
table of changes made to each account so I can run reports based on the type
of change and date of change that occured. Any ideas how I can capture only
the accounts that have a status change?

 

[KARL DEWEY]

Post your table structure with field names and datatype. Post sample data
with notation as to what might constitute a change.