I cannot see your sql statement from my PC. :) Seruously, try to create insert statement just with key field(s) and datetime filed. If it still doesnt work post code back here.


>Ok, I've recovered from the BFoMP and have built my sql statement with the variable VALUES this time, but now when I hit the first date to datetime field, I'm getting a syntax error on BOTH sides (Fox and Access). I noticed in a response you made to another person who has the joy of working with Access about the '#' character needing to be leading and trailing a datetime value, but I still get the Syntax error.

>>Dorris,
>>
>>First, there's a limit of 8,192 characters per command line in VFP. If there're more VFP generates 'Syntax error'. Second, you cannot use VFP variables directly in SQL statements in SQLEXEC(). However you can use parameters in SQLEXEC()

msql1 = "Insert into VendorMaster (pk_vend) values (?pkvend)"
>>x = sqlexec(mchand,msql1,"drslts")

In this example parameter ?pkvend will be substituted with the value of variable m.pkvend before SQL statement is executed.

< snip >