Hi Tony,

Just got your phone message about this. I don't have a lot of time right now to think about it, but here are a few thoughts.
You are doing more with this than we did, we use a range of different observation/evidence types for badgers, water voles etc. but haven't tried implementing abundances at the same time. It looks as if the import wizard cannot distinguish between different uses of the measurement type. I think this is because you are matching your abundance data column with R6's generic "abundance data", which somehow then causes this mess

I would be tempted to try something like this.

At the top of the Measurement Type term list form, under Abundance, add a new Measurement Qualifier of ActiveHole, or Burrow (burrow might already be there) or similar, then when matching the field in the wizard, instead of selecting Abundance Data, scroll down to <more options>, then Taxon occurrence data, then look for an option which says Abundance of Burrow (Count).

This should then allow the columns to be validated so the first one lists items like 1 Burrow, 17 Burrow etc. (or maybe just the numbers) without involving the items in the other column. I think it effectively filters on the measurement qualifier, rather than involving all the measurement qualifiers it can find.

I haven't tested this, but I think it is the solution.

Glad to help out. I'd be interested to know if it works with comma separated values (as it normally does with abundances). E.g. what does it do if it comes across something like "12 Active holes, 2 disused holes" (assuming that additional qualifiers had been set up of course). It ought to work, producing multiple abundance records with different qualifiers.

Hard to say without seeing all the datasets in front of me, but it is likely to be something similar to the problem Tony was having. Are you sure you are matching the fields the same way in both the excel and access versions?