>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
*If* I remember correctly - you can't. Its an issue with the ODBC driver - it doesnt let you pass .nulls. to SQL Server datetime fields.
ICQ 10556 (ya), 254117