>I am using SQLCONNECT and SQLEXEC to connect to and insert records into SQL and VFP tables. When I do a SQLEXEC with an insert into and one of the fields being inserted is a blank date where I set the field ={} I get an error from aerrors from the vfp tables ONLY that states "[Microsoft] [ODBC Visual FoxPro Driver] Data Type mismatch."
>
>What am I doing wrong ?
>
>Thanks For Your Help !
>Stephen J. Hunt

In SQL Server table make date fields to accept NULL then in your insert instead of blank dates insert NULL to them.