Ken,

TTOC() might work better than DTOC(). You can also use ? to indicate to FoxPro that it should pass the value of a variable to ODBC rather than the variable itself. Try this:

cString="UPDATE myTable SET dt_Start = ?m.DateTimeVar ..."

>I'm trying to send a datetime value via ODBC to an Access table. The expression is embedded in a string like this:
>
>cString = "UPDATE myTable SET dt_Start = ' + DTOC( DateTime variable ) + '...rest of the string'
>
>nRslt = SQLEXEC( nHandle, cString )
>
>How do I format the string?