Be Excellent To Each Other

Yeah, it's me asking for help again, but at least it's not some obscure Access question this time.

I have a spreadsheet with about 45000 rows on it, each row contains an address (but this is a list of shipping records, so I don't have 45000 unique addresses).
I need to import these into MapPoint, but when I do, I get about 6000 unmatched records, for each of these, I can either skip the record, or accept MapPoint's suggested location. Or I can just skip the whole lot.
Now, I've tried going through some of the unmatched records and changing the address in the spreadsheet to match the location that MapPoint is suggesting, but I'm still getting stuff like this:
and I'm not sure what I can do to that (and others similar to it) to make it import without issue.
I don't really want to hit ok 6000 times, anyone got any ideas?

I don't suppose you can stick a weight on the Return key?

I've been having a few sessions of just holding it down, but there's still over 5000 to go.
Of course there might be some in there that I don't want to match, but I'm not reviewing all 6000 of them.

Do you have some sort of office intern who could be bribed to do it for a fiver?

I asked GJ if she wanted to earn an extra fiver, but apparently not.
It has occured to me there's probably an option to import everything as the suggested location, but I'm down to about 1800 now anyway.

Does it go any faster if you tap it? I was thinking that maybe the Hyper Sports sessions might have helped you build up some speed

Can't you remove all the business names?

I don't think they're an issue, otherwise it wouldn't have imported anything.

Possibly... depends on how good the Geocoder is though. Could also be something else. Guess you'll just have to play around.