Update Multiple Fields at Once

[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!

 

[eyal8r]

The Table1 is actually a linked table from another application- I don't want to change that table at all- just copy the info out of it into MY table (Table2). From there, I manipulate the data, then normalize and split it up into about 8 different tables (about a level 4 normalization). Appending won't work- I need an update.

 

[neileg]

If you are repeating code you could always write the SQL in Word so you can use copy and paste, and then paste that into the SQL view of a blank query.

 

[eyal8r]

Yes, but not in Access. They are added at various times in a different software package.