How to copy all record on a table to another existing table?

[metad]

I have a table with employees’ information. I want to copy all records in this table to another existing table “WorkTimes”. I do not want to edit my employee table, so therefore I want to copy all records to another table before editing/adding information in other fields. How I can do that with a macro or module?

Thanks in advance.

 

[statsman]

Try an update query

 

[neileg]

If you need to duplicate data that is already in your data base, you have a design problem. Your data is not normalised. All you should need to use in your WorkTimes table is the employee ID.