Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Darcy Jones   on Mar 23 In MS Office Category.

  
Question Answered By: Willis Hill   on Mar 23

I think that the easiest way of doing this is to alter the
original database  itself to record  a timestamp on each record in each
table, identifying  the last time that record was updated  (best done
with a automated Trigger).

Once this has been achieved then a timestamp could also be included
in the XL identifying the same thing.

Then when it comes to updating, you only need to import records which
have been updated more recently than time X.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Identifying which row has been modified? Or get search suggestion and latest updates.


Tagged: