Copy & Replace Existing Records Function in Access?

[oblivion86]

Hi all,

Is there a copy and replace existing records function in access?

I.e. I would want to copy records from one table to another (with same structure) and replace similar records with in original table in the new records (which have minor ammendments made).

Thanks.

 

[Alansidman]

To copy your records from one table to a new table. Create a Make Table Query.

To change the records, you would use an update query.

Look at this site if you are unfamiliar with either of these concepts.

MakeTable http://search.atomz.com/search/?sp-.../www.databasedev.co.uk/table-of-contents.html

Update http://search.atomz.com/search/?sp-...//www.databasedev.co.uk/table-of-contents.htm

 

[oblivion86]

Thanks guys! Sorry for the long break between posting and replying, been busy with work, i shall try the solutions offered and get back with results.

Thanks again.