Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Copying and Pasting Records from one table to the next

Discussion in 'Information Technology' started by paul69, Jul 28, 2006.

  1. paul69

    paul69
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    paul69 wrote:
    > 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.


    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. paul69

    paul69
    Expand Collapse
    Guest

    "Rick Brandt" wrote:

    > paul69 wrote:
    > > 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.
    >
    > 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, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    paul69 wrote:

    > 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, Microsoft Access MVP
    > > Email (as appropriate) to...
    > > RBrandt at Hunter dot com


    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.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page