Copy and Paste

N

N i M d A

Hi all,

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

Thanks in advance
 
J

John W. Vinson/MVP

N i M d A said:
Hi all,

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

Thanks in advance
Click to expand...

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.
 
N

N i M d A

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

thanks
 
J

John W. Vinson/MVP

N i M d A said:
copy records from access table & paste it to another existing table in the
same access database
Click to expand...

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

N i M d A

thanks man it works :)


John W. Vinson/MVP said:
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!
Click to expand...
 
Top