Updating one table from another

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I need to update one access table from another in a way that all new records
are inserted and all existing records are updated. Is there an example of
this that I can follow?

Thanks

Regards
 
I'd look into creating a saved Access query (or queries) that can
handle the job for you. You can call them from command objects.

--Mary
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Incrementally reading in table data 4
Access Updating inventory levels 0
SQLBulkCopy like for update? 1
Insert between separate databases 5
DataAdapter.Update 1
dataset update 0
Copying a Record from one DataTable to Another. 4

Back
Top