Если по английски читать умеете, то ответ тут:
click

авторThis code will insert a FoxPro Date value but not a DateTime value.

First, be sure to verfiy whether you've got a Date or DateTime value in the FoxPro table. Using SQL Pass-through, for a DateTime value you can use DToT (Date to Time), or write the DateTime value in the correct format:

Insert Into MyTable Values (DToT{^2006/02/20})

Insert Into MyTable Values ({^2006/02/20 20:33:19})

Even so, you'll always be better off with a parameterized Insert statement as PJ. suggested. That way OLE DB takes care of "translating" the data value.

One more thing - I see you've got a T as your last parameter. Are you trying to represent "True?" If that is the case, FoxPro Logical (Boolean) values are written in text as .T. and .F. and Null is written as .NULL. .

Insert Into [5.dbf] values ({^2006/02/20 20:33:19}, 'leton', 23, 'question', .T.)

Oh - and I see you've got Insert Into [5.dbf]... Is "[5.dbf]" the name of the table? In SQL Pass-through a table is usually represented by it's name only, without the DBF extension. Also, Fox tables must begin with an alpha character or an underscore. Digits can only be used after the first character. Even though you may be able to use a non-standard table name, if you have the abililty to change the name of this table you should do so.