Table synchronize??

  • Thread starter Thread starter JKlein
  • Start date Start date
J

JKlein

I am looking for a way to synchronize tables. I have a db that I can not
link to, but I can create a tbl_TempCustomer table from a query in that db.
If I had a way to compare the created tbl_TempCustomers with my
tbl_Customers and look for record additions and record changes then I could
process the data into the tbl_Customers accordingly. Before I begin this
route I wander if there is code out there somewhere that could save me some
time.
 
always include an extra field in your table called [Last Updated] as
date/time

update this with Now() everytime a record is changed/created
 
Back
Top