Ah. Understood.
If the data isn't sensitive, could you attach one of the test files so we can see if there's a better way? If it is sensitive, could you doctor up a version that I could try for you? It would also be handy if you posted the CREATE TABLE script for the final destination table.
--Jeff Moden
Change is inevitable... Change for the better is not.