>I am appending records in a VFP table to the corresponding SQL table using a remote view. About 1/4 of them append properly. The remainder generate an error indicating that conversion of character data to datetime has created an out-of-range datetime value. All 7 of the SQL datetime fields correspond VFP date fields. Any ideas what am I missing here?
SQL Server dateime data type doesn't support dates before 01/01/1753 and it doesn't support empty values either.
--sb--