Update Multiple Fields at Same Time?

[eyal8r]

Hey guys-
I have 2 identical tables. I want to update the data from Table1 to go into Table2. Each table has well over 70+ fields in them. Instead of handwriting out each

.[Field] in either SQL or the Designer- is there a shortcut to tell Access to grab all the fields from Table1 and update all the fields in Table2 (all the fields have the same name)? I just don't have the energy to type it all out- I figure there's got to be a way...

I know when you do an APPEND query in the designer- it will do this for you- but not the UPDATE query...
Thanks!

 

[JerryKlmns]

How about delete those records form table2 and append them?

That would be faster, wouldn't be?

 

[eyal8r]

Because there's existing records in there that need to be updated and kept- not deleted...