If you use the import wizard in SQL, as it generates the scripts to import the tables, change the datatype from smalldatetime to datetime. Then import the date from VFP as DTOC(datefield). SQL will accept that import.
HTH,
Bill
>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.
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!