>>it's the voucher_date value. can you tell vfp to do a passthrough (exec on sql server side instead of in vfp)?
>
>Isn't that what I'm doing with the SQLEXEC command?

oh yeah...

try putting your sql statement into a variable and execute that way. the problem may be that vfp is asking you to build a string for the sql. if this is direct copy from your prg, should be

=sqlexec(lnConnect,"insert into myTable "+;
     "(field1, field2, field3) values "+;
     "(val1, val2, val3)" etc...