Craig - thank you so much for the quick reply.

We found that the method you suggested will work, and we also found a way we could do this using bcp.