Using VFP 6.0 and a test database of 2000 records, I ran the Upsize wizard to push the data to SQL Server 7.0. All went well, but every date field that is empty (not NULL, just empty) in the VFP table defaulted to 1/1/1900 in the SQL table. Nulls was checked on for the SQL table, I chose NOT to upsize Indexes, Relations or Defaults. Any ideas?
Oct 31 = Dec 25