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?

TIA

Ken