>Hi Again,
>I have done as you suggested, it took a while...I found Five fields that got the data type mismatch error on. I checked both tables, they have the same data and no NULLS, I replaced all index's on the original "import to table". I also tried replace field with "String" and replace field with 9999. Both gave the error. The field is C(10). I am at a loss, what do you think?
>TIA
>Rick
Rick, you might try removing the indexes (or changing primary & candidate indexes to regular temporarily) to see if that has any effect.
HTH
Barbara