I'm trying to import a VFP table that contains a date field using the SQL server DTS Import (no special data transformation). The date field is not allowing the import to work as it seems to be incompatible with the SQL7 smalldatetime field. How do I transform the date field so that it will work with SQL7? TIA