Results 1 to 6 of 6
  1. #1
    nishezaman is offline Novice
    Windows Vista Access 2002
    Join Date
    Dec 2009
    Posts
    10

    Question How to copy and paste multiple rows multiple times

    Hi All



    I am new to Access. I have a table of 5 fields and more than 5,000 records(rows). I need to copy all the rows and paste it 100 times in the new record row .


    Could you help me how to do it? If Example:

    ID Fld1 Fld2 Fld3 Fld4 Fld5
    1 2 3 5 7 9
    ..
    5000 4 3 4 5 10

    Now I need to copy all these 5000 records 100 times to make it like

    ID Fld1 Fld2 Fld3 Fld4 Fld5
    1 2 3 5 7 9
    ..
    5000 4 3 4 5 10
    1 2 3 5 7 9
    ..
    5000 4 3 4 5 10
    1 2 3 5 7 9
    ..
    5000 4 3 4 5 10
    ....


    I think Access will automatically update the ID No's


    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    Are you just trying to make a table with a lot of records? Is this just a one time operation or will you be doing it on a regular basis?

  3. #3
    nishezaman is offline Novice
    Windows Vista Access 2002
    Join Date
    Dec 2009
    Posts
    10
    Hi

    I have to do it on a regular basis. If it is one time I would just copy and paste. Please help to write any query/VB to make it automated.

    Thanks

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    Why the same 5000 records 100 times? Just to make a large table?

  5. #5
    nishezaman is offline Novice
    Windows Vista Access 2002
    Join Date
    Dec 2009
    Posts
    10
    Yes it's gonna be a huge table. It can be different number of rows, different number of times. After copying the first set so many times then I will update other sets data using some other query's for which I also asked for help on this forum.

    Thanks

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    My question was it just seems like the main goal is to make a large table. No other reason.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-06-2011, 04:18 PM
  2. Replies: 1
    Last Post: 12-10-2009, 08:41 PM
  3. Replies: 0
    Last Post: 10-15-2009, 02:08 PM
  4. Access to Excel transferring multiple rows to single row
    By peter_lawton in forum Import/Export Data
    Replies: 10
    Last Post: 09-23-2009, 10:16 AM
  5. Combine multiple rows into one cell
    By zarfx4 in forum Queries
    Replies: 8
    Last Post: 06-08-2009, 10:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums