Thanks for the info. I'll give it a look. Yes you got the right idea basically from my post. Each one of these 3 character keys is for a separate record in a junction table, so I'll have to loop anyway to perform the inserts once for each key. Still your suggestion may be a better option.