Thanks Ray! My idea was after my initial test to be sure I have a handle on it, is to ask the client to send me separate spread sheets, one for each category (9). I thought, before you posted, that I could get all the products in one category, insert, then assign a category number to that batch, rinse and repeat for each batch. Smaller spread sheets would be easier to manage, at any rate.
But if there is an easier way, I'd love to go that route.