Hello,

I have an excel spreadsheet where I have the data. The columns I am interested in are:
Ref_no, Rule_detail, Location1, Location2, Location3.

In my access db, I have three tables with fields:
1. tbl[Rule_details]
RuleID
Ref_no,
Rule_detail

2. tbl[Location]
LocationID
LocationName

The above two tables are linked as many to many.
...