Copying and Pasting Records from one table to the next

[Guest]

I want to copy records from one table in a mdb file (2002) to another table
in a 2nd mdb file. The structure of the two tables is the same. I opened up
both mdb files, then copied all the records from the first table. I then
moved the cursor over to the table of the 2nd file, went to the last record
with the asterich and tried to paste these records in. I was not able to and
received an error message stating that the record was too small for all the
data...as if I was trying to paste all the records from the first table into
one record of the 2nd table. What am I doing wrong?

 

[Rick Brandt]

I want to copy records from one table in a mdb file (2002) to
another table in a 2nd mdb file. The structure of the two tables is
the same. I opened up both mdb files, then copied all the records
from the first table. I then moved the cursor over to the table of
the 2nd file, went to the last record with the asterich and tried to
paste these records in. I was not able to and received an error
message stating that the record was too small for all the data...as
if I was trying to paste all the records from the first table into
one record of the 2nd table. What am I doing wrong?

Your pasting into the first *field*. Click on the record selector to highlight
the entire row and then paste. Excel "knows" to take multiple cells from the
clipboard and span them into multiple cells when you paste. A database grid
does not have this feature.

 

[Guest]

Your pasting into the first *field*. Click on the record selector to highlight
the entire row and then paste. Excel "knows" to take multiple cells from the
clipboard and span them into multiple cells when you paste. A database grid
does not have this feature.

Hi Rick,

Thanks for your note and suggestion. I have tried highlighting the whole
last record and still the same error message. Any suggestions? I have done
this many times before with success..I have no idea why I can't do it this
time.

 

[Rick Brandt]

Thanks for your note and suggestion. I have tried highlighting the
whole last record and still the same error message. Any suggestions?
I have done this many times before with success..I have no idea why I
can't do it this time.

The columns might not be in the same order. Copying and pasting is really not a
great way to move data in a database anyway. Linking and then using an append
query wuld be better.