Copy Records from Query Col. to Table Col.

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

Rebecca

Greetings.

I am a newbie with MS ACCESS 2002. I did a query and I
need to copy the results 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 (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.
 
Hi,


It is not very clear how 400 000 can fit into 65 000. In theory, there
is no problem handling 400 000 records, either with Jet, either with any
version of MS SQL Server. The easiest way would be to make a query to append
the records.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top