Can you tell me if failure is "all or nothing"? In other words, if some row from the Select contains an illegal value, does the entire insert fail? I should be able to figure this out myself if I could ever get it to work <g>.