Did you try:

INSERT INTO mytable (created) VALUES ({^2006-10-10 11:11:11 PM})

>Having an issue trying to store datetime (type T) values into a VFP9.1 table using VFPOLEDB 9.1. I'm doing this via ADO under C++. The following query:
>
>INSERT INTO mytable (created) VALUES ({^2006-10-10,11:11:11p})
>
>works fine within FoxPro, but the VFPOLEDB provider returns a "Data type mismatch" error. I have tried about every mutation of the date string you can imagine, and have tried using CTOT, and DATETIME functions. Everything I try returns a datatype mismatch. I can store other data types without trouble. Any suggestions?