copy records from table

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
 
H

hcj

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

This should work for you.
 
D

dimwit

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]
 
D

dimwit

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