How to make excel rows into an Access Record

[Paul Mernaugh]

I have a spreadsheet that has varying rows for each record and want to
import this into Access. For example, Row 1 is the subject. Rows 2,3,4 are
fields for Row 1. Row 5 is the subject, yet 6 and 7 are fields for Row 5 and
so on. The Subject is in column 1 and subsequent columns are descriptions of
the record. How do I import this into access so that each group, or Record
appear in Access as 1 record, and not a record for each row?

Any help would be appreciated.

Thanks,

Nigel