>TransformCopy 'DirectCopyXForm' conversion error: Conversion invalid for datatypes
>on column_pair3 (source column 'fiscal_year' (DBTYPE_NUMERIC), destination column
>'fiscal_year' (DBTYPE_R8)).

Books Online says there should be no problem doing an implicit conversion between Numeric and Real, so there must be something else going on. What's the data in the VFP tables like? Any out-of-band values, such as negatives? How about blanks, or nulls?