Copy from Query to Table Column

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Greetings again, and please forgive me for re-posting, but
the original post seems to have gotten lost in the shuffle.

I am a newbie with MS ACCESS 2002. I did a query and I
need to copy the results of this query into an empty
column in another table. The amount to be copied is over
400,000 records, so I can't copy the whole column and dump
the contents into the blank column in the table (the
65,000 limit). In very easy English, could you please
tell me how this can be done? Please keep in mind that I
am a newbie. Thanks.
 
Rebecca

You want to update 400,000 rows of a table with a new column value? If I
might ask, is there a chance that the value you wish to insert is
"calculated"? If so, why bother?

Check Access HELP on the subject of "update query". The concept is that
you'll join the table to be updated with the query you already have in the
query design window, then change the query type to "update". Finally,
indicate the field (in your table) that will be updated, and the field from
your query that provides the updated value.

Just in case, work with a copy of your database to prove to yourself that it
worked correctly.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top