Is there a way to duplicate records in an Access table?

[JSL]

The data I imported has a "quantity" field that may be >100 but I need
individual records for each of the 100. Currently the item listed is 1
record. I know how to duplicate the field above using CTRL+", but am looking
for an easier way to duplicate the entire record (about 100 times).

 

[KARL DEWEY]

Create a table named CountNumber with field named CountNUM containing 1 to 100.
Put both tables in your append query. Add CountNUM to the field row of the
grid and criteria of <=[quantity]