The problem is that SQL Server has no concept of an empty date like VFP. And the ODBC driver converts empty dates to 01/01/1900. In SQL server, the date is either valid or null (never "empty").

You might try altering your local table and replacing all the empty date fields with null before upsizing.

ALTER TABLE yourtable ALTER COLUMN yourdatefield NULL
REPLACE ALL yourdatefield WITH NULL FOR EMPTY(yourdatefield)



>Moving VFP data to SQL is via the Upsize wizard of VFP 9. How do you upsize empty 'date' fields to fill with nulls rather than '01/01/1900', yes 1900. I have tried all of the upsize options (step 8) and in all cases any empty 'date' field is populated with '01/01/1900' when it arrives in the SQL table. The upsize wizard uses the ODBC connection to connect with the sql server.
>
>Dallas