import updated records

R

Rick Campbell

I have a large database which I would like to update once a month. My
problem is that access won't import the changed records because of the key
field, which is set to no duplicates. There must be a way to do this. Can
anyone provide some hints?

TIA

Rick
 
D

Dave Miller

Try creating an import table that is an exact copy of the table you
want to update. Then import your new data to the import table, and
run an update query to update the original tables data.

Dave
 
R

Rick Campbell

Hi Dave,

Thanks! I must be suffering brain damage, or just plain old burn-out.
 
Top