Adding Date to table field

S

souchie40

Yet another question from a stuck amateur user, I have a function that
imports data from an external db, on completion of this I would like to write
to the destination table the date that it was last updated anyone with any
ideas in how to do this?

TIA
 
S

souchie40

Hi,

The import function works from a VBA module that first deletes a linked
table then refreshes the link then using a delete query it looks for
unmateched in source and destination and deletes those, then runs an update
query, followed by an append query, now I'm not to worried which way round
the date is record but I guess what I'm after is the date the destination
table was last updated.

TIA
 
Top