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