import updated records

  • Thread starter Thread starter Rick Campbell
  • Start date Start date
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
 
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
 
Hi Dave,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update certain record fields in one table if data exists in anothe 1
How to export table from outlook into ms access table? 0
Importing new records to a table 2
Importing Text Files Into Access 1
Dealing with unparseable records 4
Append new and changed records 2
Import Huge Text File 2
Copy Master and Sub record to an exisiting record with specified P 30

Back
Top