I'm trying to import a VFP table that has a date field. The SQL 7 import wants to import it as a smalldatetime datatype. However when the import is tried, an error is created.

How do I convert the VFP date field so that it can be imported into SQL7? TIA.