That is the catch. I know that I can use Append From, Copy To, but what do I have to do? Do I have to watch each field for on each iteration and expand the field in the table if the incoming information is larger then the field will accept? You can't do that and use Append From or Copy To. So do I have to read the csv file twice. One scan to find the largest field size required for each field, and the to create a table to hold it, and then again using the Append From command. Seems kind of labor intensive. I would think that there would be an easier way that I am just missing.

What do you guys think?

DJ Hunt :o)