Copy and Paste

[N i M d A]

Hi all,

How can I copy & paste more than 65,000 records in access?

Thanks in advance

 

[Ron2006]

Use an append query ... possibly

 

[John W. Vinson/MVP]

Hi all,

How can I copy & paste more than 65,000 records in access?

Thanks in advance

Copy and paste is only rarely appropriate for Access.

If the real question is "How can I copy more than 65000 records from <some
unstated source> into an Access table" the answer is to use an Append query;
if the source of data is external to Access, you can probably use File...
Get External Data... Link to link to it, and base an append query on the
linked table.

 

[Douglas J. Steele]

Copy from where?

 

[N i M d A]

copy records from access table & paste it to another existing table in the
same access database

thanks

 

[John W. Vinson/MVP]

copy records from access table & paste it to another existing table in the
same access database

Create a Query based on the source table, using whatever criteria you need
to select the desired records. Change it to an Append query and select the
second table to append the records to. If the fieldnames don't match exactly
you may need to specify which field gets appended to which.

Note that storing data redundantly in two different tables is rarely either
necessary nor a good idea; just be sure that you really need to do this!

 

[N i M d A]

thanks man it works

Create a Query based on the source table, using whatever criteria you need
to select the desired records. Change it to an Append query and select the
second table to append the records to. If the fieldnames don't match
exactly you may need to specify which field gets appended to which.

Note that storing data redundantly in two different tables is rarely
either necessary nor a good idea; just be sure that you really need to do
this!