SQL UPDATE for "edited" records
 

So for the first time I am using the external data functions of Excel to
overlay Access, the reason is that everyone here is afraid of Access...

I have today figured out how to get the info into Excel and back into
Access, but what I am currently doing is deleting the table in Access and
replacing everything with the range from Excel. Can I get some feedback on
an improved way to handle this? I would like to just Update or Append for
items that were edited in the Excel file after the data was imported on open.
The table residing in Access is 42 Columns and over 25000+ rows in length.

Would I use something like Private Sub Worksheet_Change(ByVal Target As
Range) ??? This seems cumbersome, does anyone have some suggestions?

-Steven M. Britton