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.

 

[sfreeman@co.mer]

Look at an Append Query.

Just an FYI, but this sounds like you might be violating rules of normalization by having the same records twice in the same db.