>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.

The main problem is that you probably have empty dates in the VFP table. What we do is set them all to the lowest range of smalldatetime which is 1/1/1900, and then we do a replace on any dates that are 1/1/1900 to null. Or, you could set them as null in your VFP table. We imported a 2.6 table so we did it with the above method.