Thanks for the quick resposne!

To answer your questions:

1. In both the Database Table and Free Table the NULL check box for all fields is unchecked.

2. From what I can tell it is always the same fields that drop off, short field names - 10 char or less (same field name, type, & length in both Database Table and Free Table).

3. Never anything dropping off on the long field names due to the necessary REPLACE statements I've added.

4. The code at the bottom of the original post is basically what's in my program except I have many more REPLACE statement becuase their are quite a few long field names.

I though of ditching scatter/gather and going with 250 REPLACE statements but I'm trying to avoid poor techniques.

Regards,
Torrey