copy records from table

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

Hi,

I have a table with about 6000 records. I also have
another with the same structure but only 700 records.
How do I copy the records from the table with 700 records
into the table with 6000 records? What is the easiest
way?

I tried selecting all record and then hitting "Ctrl + C"
and then "Ctrl + V", but nothing happens. Only 1 record
is pasted.

Thanks in advance,
geebee
 
Hi geebee,
Use an Append query with the short table as the source.

This should work for you.
 
if you find update query burdensome you can use this alternative
press [ctrl+a] on the table with 700 records then click on the left most side of a single record this will highlight all your field then press [ctrl+v]
 
dimwit said:
if you find update query burdensome you can use this alternative
press [ctrl+a] then [ctrl+c] on the table with 700 records then click on the left most side of a single record this will highlight all your field then press [ctrl+v]


geebee said:
Hi,

I have a table with about 6000 records. I also have
another with the same structure but only 700 records.
How do I copy the records from the table with 700 records
into the table with 6000 records? What is the easiest
way?

I tried selecting all record and then hitting "Ctrl + C"
and then "Ctrl + V", but nothing happens. Only 1 record
is pasted.

Thanks in advance,
geebee
Click to expand...
Click to expand...
 
Back
Top