>>I'm using the DTC services on SqlServer 7.0 to import a DBF. The DBF has 16,000 rows and 75 fields. The error log tells me which row caused the error, but not which field. With 75 fields, that's relevant. If there a way to determine which field is causing the error? The error message is "Invalid character value for cast specification".
>>
>>TIA
>>Bill
>
>I don't know how much help this is going to be but I do know that DTS (and BCP) don't handle VFP's empty dates.
>
>-Mike

So if this is the case, how to go about to ensure a successful mirgration
of DBF data to SQL Server?