I'm wondering if there is a way to import a one-to-many relationship from an Excel spreadsheet into an Access database.
Presently, the data is represented in Excel by a semi-colon separated list in the cells of a column, representing the OtM relationship.
For example, a cell in the Excel spreadsheet might contain "3;20;23", indicating a relationship to another table's rows with IDs (primary keys) of 1, 20, and 23.
NOTE: this appears to be the same format when an existing Access one-to-many relationship is exported from Access to Excel.
I'm struggling to find a way to import this Excel data into Access.
Can anyone kindly advise (or link to documentation) as to how I would setup my Access database, and format the Excel data to import such data into Access?
Many thanks in advance.
MM.